Re: DateCreated
From: Rob Kings (greeneggsandham_at_greymouse.co.uk)
Date: 11/05/04
- Next message: Wart: "Re: Where are ADO Recordset properties InsertCommand, UpdateCommand and DeleteCommand?"
- Previous message: Al Reid: "Re: DateCreated"
- In reply to: Al Reid: "Re: DateCreated"
- Next in thread: Al Reid: "Re: DateCreated"
- Reply: Al Reid: "Re: DateCreated"
- Reply: Paul Clement: "Re: DateCreated"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 5 Nov 2004 19:28:52 -0000
Al
You are a star. That fixed the problem. The bad news is that there appear to
be any number of other field names to which it objects. I may have my work
cut out.
All I want to know is when the database was created. I wonder if there is a
better way.
Rob
Al Reid wrote:
> "Rob Kings" <greeneggsandham@greymouse.co.uk> wrote in message
> news:2v2163F2g425sU1@uni-berlin.de...
>> Al
>>
>> Well I tried that, and then for good measure I tried cutting the SQL
>> right down to
>>
>> sSQL = "select IDNAM from Identity"
>
> I posted a follow-up. Try the following:
>
> sSQL = "select IDNAM from [Identity]"
>
>>
>> and it still doesn't work.
>>
>> Rob
>>
>>
>>> My gut feeling is if you change vbCR to vbCRLF or vbNewLine it will
>>> work. I will see if I can knock something together to prove it.
- Next message: Wart: "Re: Where are ADO Recordset properties InsertCommand, UpdateCommand and DeleteCommand?"
- Previous message: Al Reid: "Re: DateCreated"
- In reply to: Al Reid: "Re: DateCreated"
- Next in thread: Al Reid: "Re: DateCreated"
- Reply: Al Reid: "Re: DateCreated"
- Reply: Paul Clement: "Re: DateCreated"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
