Delete from Relations where RelationTable='Rent Information'

GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', '__OPTIONS__', 'Дължим и платен наем', '__OPTIONS__', 'Rent Information', '__OPTIONS__', 1, GetFreeNInRelations('Rent Information',null,null,5), '__OPTIONS__', '', '', 0, 0, '', '', '', 'call FillOweRentForMonth()', 1, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'bvrSpravkaY1', 'Дължим и платен наем', 'Година От', 'Rent Information', 'Year From', 2, GetFreeNInRelations('Rent Information',null,null,5), 'bvrSpravkaY1', '', '', 0, 0, '1', '1', '', 'select YEAR(today(*))', 20, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'bvrSpravkaM1', 'Дължим и платен наем', 'Месец От', 'Rent Information', 'Month From', 2, GetFreeNInRelations('Rent Information',null,null,5), 'bvrSpravkaM1', '', '', 0, 0, '1', '1', '', 'select MONTH(today(*))', 20, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'bvrSpravkaY2', 'Дължим и платен наем', 'Година До', 'Rent Information', 'Year To', 2, GetFreeNInRelations('Rent Information',null,null,5), 'bvrSpravkaY2', '', '', 0, 0, '1', '1', '', 'select YEAR(today(*))', 20, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'bvrSpravkaM2', 'Дължим и платен наем', 'Месец До', 'Rent Information', 'Month To', 2, GetFreeNInRelations('Rent Information',null,null,5), 'bvrSpravkaM2', '', '', 0, 0, '1', '1', '', 'select MONTH(today(*))', 20, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Month', 'Дължим и платен наем', 'Месец', 'Rent Information', 'Month', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Month', '', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'DaysInMonth', 'Дължим и платен наем', 'Дни', 'Rent Information', 'DaysInMonth', 2, GetFreeNInRelations('Rent Information',null,null,5), 'sum(DaysInMonth)', 'sum(qrData.Дни)', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Year', 'Дължим и платен наем', 'Година', 'Rent Information', 'Year', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Year', '', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Name', 'Дължим и платен наем', 'Студент', 'Rent Information', 'Name', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Name', '', '', 0, 0, '', '', '', '', 120, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Uni', 'Дължим и платен наем', 'Университет', 'Rent Information', 'Uni', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Uni', '', '', 0, 0, '', '', 'select FullName from Universities', '', 200, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Spec', 'Дължим и платен наем', 'Специалност', 'Rent Information', 'Spec', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Spec', '', '', 0, 0, '', '', 'select Name from Specialities', '', 200, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Kurs', 'Дължим и платен наем', 'Курс', 'Rent Information', 'Kurs', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Kurs', '', '', 0, 0, '', '', 'select Name from Kursove', '', 100, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'FN', 'Дължим и платен наем', 'ФН', 'Rent Information', 'FN', 0, GetFreeNInRelations('Rent Information',null,null,5), 'FN', '', '', 0, 0, '', '', '', '', 50, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'City', 'Дължим и платен наем', 'Град', 'Rent Information', 'City', 0, GetFreeNInRelations('Rent Information',null,null,5), 'City', '', '', 0, 0, '', '', '', '', 120, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Address', 'Дължим и платен наем', 'Адрес', 'Rent Information', 'Address', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Address', '', '', 0, 0, '', '', '', '', 150, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'CountryName', 'Дължим и платен наем', 'Държава', 'Rent Information', 'Country', 0, GetFreeNInRelations('Rent Information',null,null,5), 'CountryName', '', '', 0, 0, '', '', 'select Description from Countries', '', 150, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Sex', 'Дължим и платен наем', 'Пол', 'Rent Information', 'Sex', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Sex', '', '', 0, 0, '', '', '', '', 30, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'PriceKind', 'Дължим и платен наем', 'Ценоразпис', 'Rent Information', 'PriceKind', 0, GetFreeNInRelations('Rent Information',null,null,5), 'PriceKind', '', '', 0, 0, '', '', 'select Description from PriceKinds', '', 120, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'PriceKindType', 'Дължим и платен наем', 'Ценоразпис Група', 'Rent Information', 'PriceKindType', 0, GetFreeNInRelations('Rent Information',null,null,5), 'PriceKindType', '', '', 0, 0, '', '', 'select Name from PriceKindTypes', '', 120, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Usluga', 'Дължим и платен наем', 'Услуга', 'Rent Information', 'Usluga', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Usluga', '', '', 0, 0, '', '', 'select ServiceName from Services', '', 150, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Kol', 'Дължим и платен наем', 'Количество', 'Rent Information', 'Kol', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Sum(Kol)', 'Sum(qrData.Количество)', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Cena', 'Дължим и платен наем', 'Цена', 'Rent Information', 'Cena', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Cena', '', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'SumOwe', 'Дължим и платен наем', 'Дължима Сума', 'Rent Information', 'SumOwe', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Sum(SumOwe)', 'Sum(qrData.Дължима Сума)', '', 0, 0, '', '', '', '', 100, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'SumPaid', 'Дължим и платен наем', 'Платена Сума', 'Rent Information', 'SumPaid', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Sum(SumPaid)', 'Sum(qrData.Платена Сума)', '', 0, 0, '', '', '', '', 100, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Razlika', 'Дължим и платен наем', 'Разлика', 'Rent Information', 'Razlika', 2, GetFreeNInRelations('Rent Information',null,null,5), 'Sum(Razlika)', 'Sum(qrData.Разлика)', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'RealDatePayed', 'Дължим и платен наем', 'Дата плащане', 'Rent Information', 'RealDatePayed', 2, GetFreeNInRelations('Rent Information',null,null,5), 'RealDatePayed', '', '', 0, 0, '', '', '', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'PayTypeStr', 'Дължим и платен наем', 'Начин на плащане', 'Rent Information', 'PayTypeStr', 2, GetFreeNInRelations('Rent Information',null,null,5), 'PayTypeStr', '', '', 0, 0, '', '', 'select PayTypeName from PayTypes', '', 100, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'RName', 'Дължим и платен наем', 'Стая', 'Rent Information', 'RName', 2, GetFreeNInRelations('Rent Information',null,null,5), 'RName', '', '', 0, 0, '', '', '', '', 60, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'BrStudenti', 'Дължим и платен наем', 'Брой Студенти', 'Rent Information', 'BrStudenti', 0, GetFreeNInRelations('Rent Information',null,null,5), 'SUM(brStudenti)', 'Sum(qrData.Брой Студенти)', '', 0, 0, '', '', '', '', 90, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('#OwePaidRentForMonth', 'Koef', 'Дължим и платен наем', 'Коефициент', 'Rent Information', 'Koef', 0, GetFreeNInRelations('Rent Information',null,null,5), 'Sum(Koef)', 'Sum(qrData.Кофициент)', '', 0, 0, '', '', '', '', 90, '', 0, 0, 1, today())
 
GO

Call InsertPravaSpravki('Rent Information');