Subject RE: [firebird-support] Link ODBC To acces : NEW RECORD : strange record view
Author Paul Mercea
If u are using query try qrydata.requery;

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adomas Urbanavicius
Sent: Monday, April 03, 2006 4:08 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Link ODBC To acces : NEW RECORD : strange record
view

Hello,
Linked MS Access via odbc to FB table.
Deletion and editing : OK.
But after inserting record, in field places we see strange values :
"#Deleted".
After closing, reopening table/form : values are correct. But while
browsing table, after insertion, in new inserted records in all places
shown values look "#Deleted".

Anyone faced this issue ?


Sample :
ID ,Name
1 Name1
2 Name2
3 Name3

Inserting (manually) records :
4, Name4
5, Name5 .

While browsing table we see :
1 Name1
2 Name2
3 Name3
#Deleted #Deleted
#Deleted #Deleted

After reopening table :
1 Name1
2 Name2
3 Name3
4 Name4
5 Name5

How to make records instantly to look ok ?



Adomas


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links