Re: open ADOQuery with SQL-2000 raise error message and close the application

From: Yaron Nahum (yaron_at_mikunim.co.il)
Date: 02/02/04 

Date: Mon, 2 Feb 2004 11:56:50 +0200

Hi,

after much work on this case I figure out that the bug is when inserting
null string into the database

but having the same project on D5 works fine ......

Bye Yaron.

"Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
news:9iej10hvepq8v27b537icg1n4skvqblegd@4ax.com...
> >if I run this app on XP it works fine
> >but on win 98 the application crushes
> I take it you are trying to enter the null string into the database. That
is
> the only way I can generate an exception in Win98.
>
> >of course there are many work around but is it a known bug ?
> I don't remember it coming up before.
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Relevant Pages

  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... All characters that are entered in the fields make their way into the database unaltered. ... Also, mysql_real_escape_stringwill take care of NOT altering data when inserting it, providing you don;t have any hidious mechanisms like magic quotes enabled. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: Code to delete/unlink Linked tables
    ... Public intLinkODBCTables As Variant, intLinkDB2Tables As Variant ... Public strLinkBackendDB As String, strLinkDSNname As String, strLinkLibName ... ' MsgBox "This database is in MDE format...I will delete/recreate ODBC ... Public Sub fncLinkDB2Table() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Establish connection with and transferring data to Access
    ... The specific problem with your code is that you need to quote string ... Dim vConnection As New ADODB.Connection ... Experiment with the object model or check the documentation for the ... Doug's code opens and writes to an existing database. ...
    (microsoft.public.word.vba.general)