TSQDataSet........

"schnitzelklopper" <[email protected]>
Newsgroups gmane.comp.lang.delphi.kylix
Message-ID <[email protected]>
Hi,

i'm writing an CGI-App with a databaselink. There is TSQLConnection 
and a TSQLDataset in my Webmodule. I need read-only access to that 
MySQL-DB, so i'm using an unidrectional Dataset (much faster, that 
DataSet isn't caching all the result of a query). When i want to 
read the result of my query, I'm using that standard 
"while-SQL1.eof=false-<DO-SOMETHING>-SQL1.Next-end;"-algorithm. 
Everythings works fine, until the field i want to read conatins an 
empty string (''). That causes the program to crash. When i want to 
get the value of the field, i'm using something like this:

.....
var s:string;
.....
.....
  s:=SQL1.fieldbyname('author').asstring;// <-- That causes the 
crash (segmentation fault (SIGDEV(11))
.....


I tried to "watch" for empty strings in that field, but everything 
that "touches" the value of the field will crash the app.

Any ideas?

Thanks for your response,

Henock
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.