What's going on in x3genpk()?
is that moving the record pointer to eof() in the scrental table?
>I have established a temporary relationship between 2 tables(scrental and sccust).
>
>as I scan through scrental, the pointer in sccust moves correctly, until I put an insert...values command within the scan. Then the pointer in sccust no longer moves correctly. Here is the code: If I remove the insert command and only leave the messagebox then it works correctly.
>
>
>select sccust
>set order to cus_acct
>select scrental
>set relation to rnt_acct into sccust
>
>select scrental
>scan
> messagebox(sccust.cus_ccno)
> insert into scautopy (aut_pk) ;
> values(padl(x3genpk("scautopy","sc"),5,"0"))
>endscan
>
>
>Any ideas?
>
>Thanks,
>Paul
Insanity: Doing the same thing over and over and expecting different results.