General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I am actually writing an application that needs to interact with a software called Visual Account Mate (which is written in VFP). Everything works fine but one thing, adding new records. My problem is caused by the presence of a general field in the table I am accessing.
I need to use ODBC because I need to access the table while other users are still logged in; accessing the tables directly wont let me do that. Now, without ODBC I can add new records even though I have a null value in the general field. However, with ODBC, an error occurs saying that the general field does not accept null values. (by the way, I use the VPF driver for my data source)
So I tried to put SPACE(10) as the default value in the field(a developer from Account Mate suggested me to do so). However, I cant even use APPEND BLANK without getting an error. If I use INSERT INTO, the new record gets created, but I still get the error message. If I handle the error I can create new records. However, when I use INSERT INTO in a program, it generates the error 'Data Source is Busy'. I can use it from the command window, but not from a program.
Can anyone help me?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only