Re: ADO and blank fields problem

From: Charles E Finkenbiner (CharlesEF__at__MailandNews.Com)
Date: 07/01/04 

Date: Thu, 01 Jul 2004 14:25:14 -0500

Hi Bob,
On 7/1/2004 10:43 AM, Bob Barrows [MVP] wrote:
> Charles E Finkenbiner wrote:
>
>>Hi Bob,
>>
>>My script is a front end (GUI) for an MS Access database. It is only
>>used from a local drive, not the internet. For this reason I thought
>>it would be OK to work with the recordset directly. Am I wrong in
>>this thinking?
>
>
> No. The recordset should be fine, although it's a perpetuation of a "bad"
> habit ...
>

Ok, I will remember to use the other method if I ever need to do
database work over the internet.

>
>>Also, the array returned by GetRows is not compatible
>>with my script language (not VBScript), so I can not work on a copy
>>of the data.
>
>
> I'm not sure why that's relevant ...
>

Well, it's not. If was recommended to me in another post as a way to
access the data without leaving the recordset open.

>
>>My update code is a loop (using Recordset.Fields.Count). Instead of
>>writing only the fields that were changed I choose to update all the
>>fields (requires less code and logic). I will try your suggestion of
>>using Null in the number fields and report back.
>>
>
> It will work
>

Yes, it did work fine. After all this I will just leave things the way
they are, using a default field value of '999999'. I mean, yes I can
test the field type etc.. but then I defeat the purpose of my small loop
code (by adding more code and logic).

> Bob Barrows

Thanks for your help,

Charles

Relevant Pages

  • Re: Newbie..Needs Help
    ... here is the website which holds the data I require ... put in this parameter or these are the meeting tracks ... I am enjoying a script that was written for me and its purpose is to ... collect data from a web site and puts it into a access database table. ...
    (comp.lang.python)
  • OWA usage analysis script
    ... For this script, you need an access database with the following fields ... ' From the book Inside Active Directory, ... Set objConnection = CreateObject ...
    (microsoft.public.exchange2000.clients)
  • Open an application using script
    ... novice as far as VB Script is concerned and would be grateful if someone could tell me ... whether you can use it to open an Access database?. ... Does the object variable go out of scope when the script finishes thus ...
    (microsoft.public.scripting.vbscript)
  • RE: Script that spans multiple files
    ... : Charles K. Clarkson wrote: ... use lib '.'; # Point to the path of your other files. ... variables you have in your script. ...
    (perl.beginners)
  • Installer and Access database sync
    ... How do I make an installer or script that set up the Access database ... syncronization relationship between the desktop and the device? ...
    (microsoft.public.pocketpc.developer)
Loading