Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Weird SQL Update Problem
Message
De
20/02/2001 08:17:05
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
20/02/2001 06:55:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00477550
Message ID:
00477571
Vues:
20
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform