 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Alan T
Guest
|
 Posted: Thu Apr 19, 2007 8:11 am Post subject: Table append problem in SQL Server but OK in Access |
 |
|
I got a table has Primary key field defined as IDENTITY field in SQL Server,
other fields are NULLABLE, and 2 fields are bit fields which are not
NULLABLE.
The same table structure in Access, primary key field is Autoincrement,
others are NULLABLE.
When I call:
table1.Append;
I gave me an exception about:
myapp.exe raised exception class EConvertError with message ''' is not a
valid integer value'.
Process stopped. Use Step or Run to continue.
This exception happened when I connect to SQL Server.
I did not get any problem when connecting to MS Access.
Any idea? |
|
| Back to top |
|
 |
CC
Guest
|
| Posted: Thu Apr 19, 2007 6:33 pm Post subject: Re: Table append problem in SQL Server but OK in Access |
|
|
On Thu, 19 Apr 2007 16:36:51 +1000, "Alan T"
<alanpltseNOSPAM (AT) yahoo (DOT) com.au> wrote:
| Quote: | I gave me an exception about:
myapp.exe raised exception class EConvertError with message ''' is not a
valid integer value'.
Process stopped. Use Step or Run to continue.
This exception happened when I connect to SQL Server.
I did not get any problem when connecting to MS Access.
|
This might not be your problem but I ran into this recently while
running queries on a SQL server (not microsoft) and it drove me mad.
I had changed the controls on a form. The old controls did not put a
comma ',' in the number it displayed and the new one did. The reason
was because I'd do something like:
query.Parameters.ParamByName('InName').value := EditControl.Text;
Passing a real SQL server an integer value with a comma in it will
generate this error. It drove me mad.
Like I said, this might not be your problem, but it gives you
something to consider. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
