P4W: Cursor stuck in form's table frame

P4W: Cursor stuck in form's table frame

Post by Carey David Klenets » Tue, 02 Nov 1993 15:26:23

Quote:>My cursor gets stuck in the table frame of a Paradox for Windows form.
>The only way I can get it out is by clicking with the mouse.

You have to use F3 and F4 (Super Tabs) to get out of the table frame, or
ObjectPAL code it to do so differently

Carey Klenetsky


P4W: Cursor stuck in form's table frame

Post by Marc P. Obu » Thu, 04 Nov 1993 01:36:50

>My cursor gets stuck in the table frame of a Paradox for Windows form.
>The only way I can get it out is by clicking with the mouse.

>I have a form which has a number of fields for data entry and also a
>tabel frame for data entry. Its like a customer order form:

>                                   Item Number    Quantity
>    Customer ID:                   -----------    --------
>    Date       :

>You fill in the date, Customer ID, and then move over to enter item
>numbers and quantities. My problem is that once the cursor moves into
>the item table frame, it won't tab out. You can press enter, tab,
>shift+tab, arrow keys, end, home, etc. The cursor moves around in the
>table but never back to the ID or date. To get back to the ID or date,
>you have to click on them with the mouse. This is a bad feature for data
>entry people who don't want to take their fingers of the keyboard.

>Why won't the cursor tab out of the table frame?


>Robert Emmons           Never hesitate to sacrifice clarity
>CalcShop Inc.           and maintainability to save precious

In my experience with this, the cursor, when it reaches the end of one
record in a table, will tabe to the first field of a new record in
that table.  You could attach a method to the last field fo the table
to tab to the field that you want it to.  attach an action method to
the last field to read :

method action( eventInfo       )

   if eventInfo.ID() = FieldForward then


or use ID.moveTo() if thats the field you want to move to.  Good Luck
with it.



1. Error Handling/Rollback Tran inside Cursor - I'm stuck

Hi all,

I have a cursor with transactions that attempts to insert a row in a table, if the insert fails, I want the transaction to rollback, and then the cursor should fetch the next row, and continue with the next row in the SELECT resultset. If it succeeds, a commit is executed...

So I tried it, and always got several hundred or thousand 'Successful' messages, followed by an infinite loop of the following:
Server: Msg 2627, Level 14, State 1, Line 4
Violation of PRIMARY KEY constraint 'PK_CSG_Data'. Cannot insert duplicate key in object 'CSG_Data'.
The statement has been terminated.
An error occurred during execution of the INSERT statement...2627  

Server: Msg 16902, Level 16, State 38, Line 37
FETCH: The value of parameter 'rownumber-type' is invalid.
next, I looked at the Books Online, and it suggests for SQL Server 7 ALL cursors should be reopened explicitly after a ROLLBACK, as there is some kind of implicit Cursor Close in a Rollback Tran...

So, I put an 'Open Cursor-Name' command after the rollback, but this gave me the same problem as previously.

So what is the correct way to do this. I want no problem if it succeeds, and if it fails row by row, it should just mention politely that it failed, and get on with the next one...the idea that eventually I can put the error rows into an erors table for checking by the users...

I am confusied, so any help or assistance would be appreciated...



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

2. Viewig PFD Files

3. I'm stuck with tedit/tdbedit cursor control - borland.txt [1/1]

4. problem about php+informix

5. Table frames linked to table frames in a report

6. unable to install sql2k EE on the cluster

7. Multi Table Forms P4W

8. Books on Oracle

9. P4W 4.5 Windows Form->Not Windows Form?

10. Table frames on a form

11. Table frame behaviour in forms

12. Pls help! Report/Form Question : Two table frames

13. Removing Fields from a Table Frame on a Form