<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
silvioprog wrote / napísal(a):
<blockquote
cite="mid:CAKq_V2+0LOwkzSTwSYmJ_z1FmSENYdF447CtrgRNpUvVkUVJSw@mail.gmail.com"
type="cite">
<div dir="ltr">2013/9/11 LacaK <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:lacak@zoznam.sk" target="_blank">lacak@zoznam.sk</a>></span><br>
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
silvioprog wrote / napísal(a):
Now doing more tests. I see, that in pgAdmin when I use right click on
table and use "View Data" then '' (two single quotes) are shown in TEXT
column, but when I use SQL and type:<br>
select * from <table name> then empty fields are shown ... so it
seems to me, that bug is in pgAdmin, does not ?<br>
-Laco.</div>
</blockquote>
<div><br>
</div>
<div>The bug is in FCL. Please see the steps in my comparison:</div>
<div><br>
</div>
<div>1. first I inserted a record via pgAdmin: insert into test (id,
fieldtext) values (1, null);</div>
</div>
</div>
</div>
</blockquote>
Try in pgAdmin do:<br>
insert into test (id, fieldtext) values (1, '');<br>
Then use "View Data" and you will see two single quotes instead of
empty cell.<br>
<br>
<blockquote
cite="mid:CAKq_V2+0LOwkzSTwSYmJ_z1FmSENYdF447CtrgRNpUvVkUVJSw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div>2. after, I executed this demo: <a moz-do-not-send="true"
href="http://pastebin.com/HS8DZkDV">http://pastebin.com/HS8DZkDV</a>;</div>
<div>3. finally, I made this selection in pgAdmin:</div>
<div> select * from test</div>
<div> where fieldtext is null;</div>
<div><br>
</div>
<div>And the result is:</div>
<div><br>
</div>
<div>id | fieldtext</div>
<div>-----------------</div>
<div>1 |</div>
<div><br>
</div>
<div>But, when I select so:</div>
<div><br>
</div>
<div>
<div>select * from test</div>
<div>where fieldtext = ''</div>
</div>
<div><br>
</div>
<div>The result is:</div>
<div><br>
</div>
<div>
<div>id | fieldtext</div>
<div>-----------------</div>
<div>2 |</div>
</div>
<div><br>
</div>
<div>Then SQLdb is saving an empty string instead of null. :o</div>
<div><br>
</div>
</div>
</div>
</div>
</blockquote>
Yes it is true for your version of bufdataset.pas, but it is fixed in
trunk.<br>
<br>
L.<br>
<br>
</body>
</html>