update problems

[Capra J'neva]

When creating a new database, it would not write
unless the fields & bases were in quotes.  When
reading from it, it won't read without them in quotes.
 Which way is it to be?

So now, when writing back into an existing database
things don't go in quotes?  But I was having trouble
with it that way too...hard crashes.


--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote:
> On 3/25/05 9:53 PM, "Capra J'neva"
> <sonicinema at yahoo.com> wrote:
> 
> > Hi, sorry I just got the tail end of the
> conversation
> > about updating, so sorry if this question has
> already
> > been answered.  I am unable to make updates to a
> > record.  When using the cursor script:
> UpdateRecord, I
> > receive a #5 error (which means somehow that it
> cannot
> > connect with a file) here is the script that
> causes
> > the error: UpdateRecord(queryObject,"user",3)
> ...By
> > the way a DeleteRecord in this same cursor
> position
> > succeeds.
> > 
> > I used the following SqlExecute:
> > SqlExecute(curDB,"UPDATE '" &baseObject&"' SET
> > 'user'=3 WHERE 'numSizes'="&numSizes&" AND
> 'user'=2",
> > 2, 3, 2)
> 
>     WHERE 'numSizes' = ..
>         ^^^^^^^^^^^^^^
> 
>         this is field ?
> 
>     then why in quotes ?
> 
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need
> for speed ]
>
-------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------------------------------------------------------
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> 
> 
> 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/