Jump to content
Sign in to follow this  
LaRetta

This is strange to me; but then many things are strange to me ... When I import from SQL query using SQL Server, I end up with a found set of imported records. I import based upon 'WHERE >' ca

Recommended Posts

This is strange to me; but then many things are strange to me ...

When I import from SQL query using SQL Server, I end up with a found set of imported records. I import based upon 'WHERE >' calculations (which are stored with FM). But when I perform the same actions using Oracle in Client 10g driver, I do NOT have a found set!! I instead end up with all records.

For testing: I show all records (75,000) so I have a total record set, then perform my import. It imports the correct records (another new 500) but status area displays 75500 and puts me on record 1 and it still says 'total' records - no found set.

This is the only time I have EVER seen FM forget to provide me with a found set after an import. Does anyone know of a workaround? I suppose I can capture the total records before and after and then jump to that first 'new' record number and omit multiple (that new number), then show omitted but ... good Lord, that's a major kludge.

Ideas appreciated.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.