Re: mapping names in SQL-DB with that of Delphi4

Posted by vas hallman on September 25, 2009

In Reply to mapping names in SQL-DB with that of Delphi4 posted by vas hallman on September 25, 2009

I have an Delphi 4 application, that extracts data from XLS 2003 sheets (filled Forms ) and inserts into SQL2005 DB .

i have a group of fields in XSL and SQL2005 called.In the Delphi code it is correspondingly called 133, 167 etc.The words around "smrBgm133GallonsGross, .." i.e "smrBgm" and "GrossGallons" are concatinated accordingly in the Delphi files.

SQL/XLS Delphi
smrBgm133GallonsGross... 133
smrBgm167GallonsGross ... 167

For the above I added a new field called in XSL/SQL called smrBgm167GallonsGrossDA

But the PROBLEM is in the Delphi it should be NAMED AS 229, NOT as 'smrBgm167GallonsGrossDA' (as per some biz rules;coz the Delphi appl, processes both EDI/XLS and EDI accepts 229)Hence getting an error while inserting and updating data via the EXCEL sheets ."saying 229 not found in DB".
(Excel sheets it is named as 'smrBgm167GallonsGrossDA' where as in Delphi it is named as '229').

How to tell the Delphi application....
"if it is " smrBgm167GallonsGrossDA" then consider it as "229"?????????????