Database Not Working

[Guest notes]

Sir Good Day, see my attached script and database. The script not taking the data from the database

what do you think the problem?Im Using Access2007 and VG 6.0v

 

Attached:

0509_1213_vgEngine.zip

[SupportTeam]

In your SQL query one of the fieldnames is the same as one of the reserverd keywords. You can try putting brackets around the FieldName in the SQL queries, but it's best to just change the database's column names to not use a reserved keyword for any of the columns.

 

In your case the table CIdlanguage has a column named: Langauage

 

Change the column name to soemthing else (eg: CallersLang) and amend the SQL queries in the script appropriately.

[SupportTeam]

Alos the SQL query in module VehicleData is wrong. The $RV is missing an end bracket

 

Right now you have:

 

SELECT VehicleBrand, VehicleType, VehicleColor, ExpireDate, Email1 FROM (AccountFile) WHERE DriverID=$RV[GetDriverNumber;

 

change

 

$RV[GetDriverNumber;

 

to

 

$RV[GetDriverNumber];

[Guest notes]

In your SQL query one of the fieldnames is the same as one of the reserverd keywords. You can try putting brackets around the FieldName in the SQL queries, but it's best to just change the database's column names to not use a reserved keyword for any of the columns.

 

In your case the table CIdlanguage has a column named: Langauage

 

Change the column name to soemthing else (eg: CallersLang) and amend the SQL queries in the script appropriately.

 

Good Day Sir, what do you mean the same as one of the reserved keywords? May I know Sir what fieldname you mention. By the way

Thanks because I forgot to put bracket.

[SupportTeam]

the table CIdlanguage has a column named: Langauage

 

Change the column name to something else (eg: CallersLang) and amend the SQL queries in the script appropriately.

 

Langauage is a reserved word.

[Guest notes]

Sir there no other way Sir instead of changing the field name from my database?

[SupportTeam]

You can try putting brackets around the FieldName in the SQL queries.

 

ie: replace

 

Language

 

with:

 

[Language]

 

wherever you see Language in your SQL queries.