I am connecting to an external database using the DSNless command:
SET VAR vcommandC = ('SCONNECT ' + '''' +
+ ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program Files (x86)\sPMS
Program\SAMS.mdb;' + '''')
&vCommandC
And then SATTACH a table using the command:
SATTACH 'SegmentData' AS 'ASegmentData' USING ALL ALIAS +
ASubSection, +
ASegmentID, +
ARoad, +
ABegSeg, +
AEndSeg, +
ADistrict, +
APavementType, +
ALength, +
AWidth, +
ATotalSize, +
ALanes, +
ADirection, +
AClass, +
ARightOfWay, +
ABegMilepost, +
AendMilepost, +
AUtilities
I can access the table and data and run queries but I am having problems trying
to delete and insert rows to the attached table. For example, the following
command does not seem to work:
DELETE ROWS FROM ASegmentData WHERE(ASubSection+ ASegmentID) +
NOT IN (SELECT seg_chk FROM features WHERE sub_sys = 'CJC')
If a project the attached table to a local table:
PROJECT TEMPORARY BSegmentData FROM ASegmentData USING *
And run the DELETE ROWS command on the projected table it works correctly so I
know the syntax is correct, same thing with the
INSERT INTO…
command, works great on the projected table but not on the SATTACHEd table.
I am obviously missing something because I am pretty sure R+Base can add/delete
rows on external databases/tables and I believe I have done this before but I
can’t seem to find that particular application. Any help will be greatly
appreciated.
Javier,
Javier Valencia, PE
O: 913-829-0888
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Thursday, February 07, 2019 11:22 AM
To: [email protected]
Subject: RE: [RBASE-L] - SQL tutorial
You can easily check this yourself. Place the following code in a command file
makings sure that vPOID has a valid value
SET ERROR VAR hold
SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus
= 'P'
IF hold = 0 THEN
Trace the code one line at the time looking at variables hold and vchk.
Look at the value for vchk and hold after the code executes the second line.
This should tell you how the ERROR VAR changes depending on whether you get a
valid value for vchk or not.
Javier,
Javier Valencia, PE
O: 913-829-0888
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of
jan johansen
Sent: Thursday, February 07, 2019 11:09 AM
To: [email protected]
Subject: Re: [RBASE-L] - SQL tutorial
Group,
Part of this didn't get answered, maybe obliquely.
In the OLD code
IF Hold = 0
Does that mean success or failure?
Jan
From: "jan johansen" <[email protected]>
To: [email protected]
Date: Tue, 05 Feb 2019 15:41:06 -0800
Subject: [RBASE-L] - SQL tutorial
All,
I think I need a SQL refresher.
I need to update old code that looks like this.
SET ERROR VAR hold
SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus
= 'P'
IF hold = 0 THEN
So is
IF hold = 0 the same as
IF SQLCODE = 0?
Sorry such a dumb question.
Jan
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
