PDA

View Full Version : Delphi/SQL/Paradox datatypes



Dolby Digital
03-06-2003, 01:54 PM
Help Delphi people... I'm using Delphi 5, a TQuery to update a Paradox db but I am having problems with data types e.g. one field is a ShortInt in Paradox. I use the AsInteger (no AsShortIint ??) function to place it into the Params array but it appears to fail when I do the ExecSQL. I have done some internet searches but cannot find that one page on the internet which tells me the answer :D

Dolby Digital
03-06-2003, 06:06 PM
Solved it... there is a AsSmallInt function...