runtime error '3421' datatype convertion error 
Author Message
 runtime error '3421' datatype convertion error

Why this keeps giving this error runtime error '3421'
datatype convertion error.

Datacri its a date field like 12-12-98 09:55:58

DB_Pe.Recordset.OpenRecordset ("SELECT " & "Min(DATACRI) AS MinData " &
"FROM Permuta;")

TIA
use this Email please

* remove Z from Email



Tue, 20 Feb 2001 03:00:00 GMT  
 runtime error '3421' datatype convertion error

Quote:

>Why this keeps giving this error runtime error '3421'
>datatype convertion error.
>Datacri its a date field like 12-12-98 09:55:58
>DB_Pe.Recordset.OpenRecordset ("SELECT " & "Min(DATACRI) AS MinData " &
>"FROM Permuta;")

SQL requires date fields bracketed by the # symbol as in ("#" & DATACRI & "#")

Quote:
>TIA
>use this Email please

>* remove Z from Email

***********************
Why am I riding in this Hand Basket and just where are we going?

Email: use glennmiy AT inreach DOT com



Tue, 20 Feb 2001 03:00:00 GMT  
 runtime error '3421' datatype convertion error

Quote:

>SQL requires date fields bracketed by the # symbol as in ("#" & DATACRI & "#")

The above is valid for MS Access SQL only.


Tue, 20 Feb 2001 03:00:00 GMT  
 runtime error '3421' datatype convertion error

Quote:


> >SQL requires date fields bracketed by the # symbol as in ("#" & DATACRI & "#")

> The above is valid for MS Access SQL only.

  Hi,

This is a testing, sorry!!



Mon, 26 Feb 2001 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. runtime error '3421' datatype convertion error

2. ADO runtime error 3421.

3. Error 3421 - Data Conversion Error - HELP!!

4. Runtime error '429' at runtime

5. Runtime error '429' at runtime

6. Runtime error '429' at runtime

7. Runtime error ''800a01b6''

8. Runtime error '429', ActiveX can't create object

9. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

10. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

11. Runtime Error '3625'

 

 
Powered by phpBB® Forum Software