Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exampe of sql update

Status
Not open for further replies.
mmt

mmt

Programmer
Dec 17, 2002
2
US
Searching for the correct syntax of a Paradox SQL Update.
It will be something like the below.

update c:\temp\ICTM.DB
set(Characteristic,
Conversion,
UOM2,
Comment) =
( select Characteristic,
Conversion,
UOM2,
Comment
from
H:\Paradox\QAGrStd\IDTM.DB
where
H:\Paradox\QAGrStd\IDTM.Control =
c:\temp\ICTM.Control)
 
Status
Not open for further replies.

Similar threads

caitlind
  • Locked
  • Question
‘Art of Indigenous Fashion’ showcases the works of Native American designers
Replies
0
Views
233
caitlind
caitlind
ebtrr
  • Locked
  • Question
Query last modify date/time of table row
Replies
1
Views
87
rum63
rum63
caitlind
  • Locked
  • Question
There are several kinds of dogs that the poor "can't accept", try not to consider them whe
Replies
0
Views
204
caitlind
caitlind
trsiskotr
  • Locked
  • Question
Paradox 9 on winxp all of a sudden printing all worksheets/tables from 2007
Replies
3
Views
118
simd01
simd01
Bubsi
  • Locked
  • Question
Reporting concatenation of records
Replies
0
Views
52
Bubsi
Bubsi

Part and Inventory Search

Sponsor

Back
Top