Hi Ian Brooke
can you send me some of your code that relate to your problem then I might help
you if I know your exact problem.OK?
thanx
Ian Brooke <[EMAIL PROTECTED]> wrote:
Hi All,
I'm looking at someone else's program here, not mine.
It's in VB6 using an Access database via a DataEnvironment. One of the tables
has a Date field (actually a number of them) and it's trying to insert values
into that field read from a text file. The DE has a command defined
(simplified) as text of "Insert into atable Values(?)" and is called from a vb
procedure passing it the new value for the date. It works fine for actual
dates but the big problem is that in some cases there is no date and it needs
to put a null value in the field. If it's called by "DE.acommand NULL" then it
generates run time error "Invalid Use of Null" and I cannot find a format that
will allow a null to be passed.
If I change the text of the DECommand to "Insert into atable Values(NULL)" then
it works fine but it isn't practical to have dozens of different update
commands depending on which dates are missing etc.
ANY ideas VERY welcome!
Thanks
Ian
[Non-text portions of this message have been removed]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
All your favorites on one personal page � Try My Yahoo!
[Non-text portions of this message have been removed]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
