🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1211

Re: Ver 7.01 => Rowset.fields["***"].value - problem

#1211
From: Karsten Tinzmann
Date: Wed, 08 Apr 1998 00:00
75 lines
3717 bytes

Romain Strieff [TeamB] wrote in message ...
>In article <6gdjtj$nha8@forums.borland.com>, promexkt@icon.co.za
>grudgingly admits...
>> Thx for your assistance :-)
And again, thx
>-----
>My pleasure.
>>
>-----
>This is _not_ about multi-user, just to be sure. Later in the program you
>use, the (perhaps single) user could just just open the same form
>multiple times, for example:
>1. he has 1 customer form open to add a new customer standing before his
>desk.
>2. a second one open, he was working on (address change) before that new
>customer came in.
>3. a third one to check a phone number a co-worker just asked him
>etc

True as well; I think I know what to do (make use of add() and delete the
variable contents on exit of form. Have seen something like that in the
definition of array class... <oref>name = new array()...

>Yes, written for 5.# but most of it should still work in 7.

Is an update in the pipeline?

>Try reinstalling the patch, that seems to be an install glitch.
>>
I am busy

Do you have an idea why I always get an Invalid Subscript Reference Error
for the following code?

function CUSTOMERGROUPNAMECOMBOBOX_onChange
       this.rowset = form.cstgrpdl1.rowset
       form.SelectedGroup = this.rowset.fields["CustomerGroup"].value
       this.form.MainNotebook.EntryField4.value = form.SelectedGroup
       return

I have applied the changes as recommended by you before. I have tried also
other versions where I defined SelectedGroup as public in the form_on_open
event. This lead to undefined variable error msg's.
I have the impression that I am missing a basic key (to unlock quite a few
doors for me) which would enable me to really progress with VdB. I have read
everything about variables supplied in the help and the manual as well as
everything I could find which had the word 'row' (e.g. rowset) and 'sql'
(e.g. lookupsql) in it. Now I'll start with the How to's. Thx for the Easter
Holidays coming up, will have to search for some knowledge in stead of some
molten chocolate eggs <g>

The Invalid Subscript Reference Error was sometimes followed by an error msg
stating that VdB has experienced a fatal internal error and will be shut
down. After VdB has shut down the file size of the form and the backup is 0
kB and I cannot open nor retrieve it. The compiled Form file (wfo) then
always has a size of 47 kB which is bigger than the originl wfm and backup
file.
>--
Thx for your support.

I see that you are a member of TeamB. I have a suggestion to Borland (maybe
you can suggest it to them): Why not start a newsgroup for newbies <like me>
that are starting to learn VdB / dBase. I am sure that this would filter out
all the less complicated problems and I suspect would actually provide quite
a bit material for a book for beginners to intermediates in VdB.

Well that's it for now...

Karsten
>Romain Strieff [TeamB]
>Want quick help? Check previous Q and A at:
>http://forumsearch.borland.com:88/ and TIs at
>http://www.borland.com/VdBASE/vdbprod.html
Technical Details
Message-ID: <6gebug$odk2@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <6garpt$kna2@forums.borland.com> <MPG.f942400466c19e698ab7f@forums.borland.com> <6gdjtj$nha8@forums.borland.com> <MPG.f9476687b33bdc498ab8b@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,f0d0f8bab29d096a
X-Google-Attributes: gidff5a1,public
From: "Karsten Tinzmann" <tinzi@iafrica.com>
Subject: Re: Ver 7.01 => Rowset.fields["***"].value - problem
Date: 1998/04/08
Message-ID: <6gebug$odk2@forums.borland.com>
X-Deja-AN: 341863701
References: <6garpt$kna2@forums.borland.com> <MPG.f942400466c19e698ab7f@forums.borland.com> <6gdjtj$nha8@forums.borland.com> <MPG.f9476687b33bdc498ab8b@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql