Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird SQL Update Problem
Message
From
20/02/2001 08:17:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/02/2001 06:55:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00477550
Message ID:
00477571
Views:
22
>Dear all,
>
>I have this problem with update statement giving an error. I have a text box in container object and this is referenced (mydate) in the UPDATE statement with error out with "Alias is not Found". Is this a bug??
>
>Table struture
>
>Field1 CHAR(10)
>Field2 DATETIME
>
>*******
>oCon = CREATEOBJECT("container")
>oCon.AddObject("mydate","textbox")
>
>UPDATE tab1 SET mydate = oCon.mydate.value WHERE field1 = 'A'
>
>******
>
>
>Thanks.
>
>Regards,
>Kueh

Kueh,
It's a known issue.

ldValue = oCon.mydate.value
UPDATE tab1 SET mydate = ldValue WHERE field1 = 'A'

works.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform