Cliff wrote on Feb 17^th, 2008 at 8:48pm:

I'm not sure what you're asking me to do, but if you want to email me (erika@hammerdata.com) or PM me we can can talk about it.

Let's start from the beginning. You should not be "importing" any data.

Yes or No. Did you add the line I gave you to the top of your text file?

OK. So far, so good.

What is the name of your main database?

Make a backup of policy.

Open xauto.
Retrieve all the records.
Mass update the records in xauto using the Mass Update I gave you.

Note that you cannot just paste it in and run it. You need to update it to match your database, form and element names. Your database is Policy, not Target. I only put in the first five as an example. You need to use more than the first five values and your element names are probably not Info1, etc. I can't tell you exactly what to type because I don't know which values from your text file go into which elements on your Policy form.

You also need to change the include path to one that is more likely to match yours.

#include "sbasic_include.sbas"

Hi Hammer:
Well...
Follows is the first few lines of the modified code you gave me:
#include "C:\Sesame2\sbasic_include.sbas"

var vRS as Int

     // Open a result set with the matching record in the target database
     vRS = @XResultSetSearch("policy.db", "Target", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Key=" + ASCII0000)
     If vRS > -1
     {
           // Make sure there is exactly one matching record
           If @XResultSetTotal(vRS) = 1
           {
                 // Update the values
                 XResultSetValue(vRS, "A1", ASCII0001)
                 XResultSetValue(vRS, "A2", ASCII0002)
                 XResultSetValue(vRS, "A3", ASCII0003)
                 XResultSetValue(vRS, "A4", ASCII0004)

All fields are completey synchronized (there are actually 95 of them).
I paste the code in the program editor in the ASCII0000 spec (the only one that shows in  the program editor other than GLOBAL CODE) and then click test.

When I do I receive an error that would probably be best sent as an image, if you click this link:

http://www.paracomm.net/Capture.JPG

You will see that the error is related to line 13 which is this line: (XResultSetValue(vRS, "A1", ASCII0001))

Dutifully, I have tried a number of things not the least of which was to fine comb the auto database files several times.

As always...any and all help is very much appreciated.

Thanks...

Cliff

Worked through the last...by adding quotes around the "ASCII0001...2...3...4" portions of the script.
Was able to run the script...
However...
Received numberous Error: Unable to open result set for + ASCII0000 errors but was able to export the data after the fact...
Exported data shows no change subsequent running the script...

workin' at it...

Cliff

Thanks...
Re: first few lines
#include "C:\Sesame2\sbasic_include.sbas"

var vRS as Int

     // Open a result set with the matching record in the target database
vRS = @XResultSetSearch("policy.db", "Target", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Key=" + ASCII0000)
If vRS > -1
{
           // Make sure there is exactly one matching record
If @XResultSetTotal(vRS) = 1
{
                 // Update the values
XResultSetValue(vRS, "A1", "ASCII0001")
XResultSetValue(vRS, "A2", "ASCII0002")

My primary database is policy...so I am taking it that "Target" should be the database name that I am running the script in? ie., xauto.db

As shown here I have ascii0001 associated with the element "a1" in the xauto database...
The very first LE in xauto is the policy number which I am assuming is the "key" by which we are syncing these two db's with and it would be ascii0000

Tx...cN