alias not found even if table is in DE

[R17]

i have a textbox with a keypress event, i use table "empRef". actually empRef is the employee table but i change the alias name to "empRef".

why am i having an "alias not found" when i try to select the table? i placed this table in the DE.

what's wrong?

 

[Redsz]

are you opening the table with the alias empref?

eg:

use employee again alias empref

 

[R17]

hi,

instead of putting the same employee table in DE, i just did some sql so select all record and save it into a cursor.

 

[ramani]

Hi R17,

When the SELECTS do not return any records, the cursor gets never opened. To avoid such a situation, you can do it..

1. Create a Form property.. cEmp and initialise the value to "" .i.e. none.

2. Just modify your SQL select as...

ThisForm.cEmp = SYS(3)
SELECT ..... INTO DBF (ThisForm.cEmp)
USE
USE (ThisForm.cEmp) IN 0 ALIAS empRef


3. Now your form will work perfectly..
To clean up the DBF you have created... add in your forms DESTROY event..

DODEFAULT()
ERASE (ThisForm.cEmp+"*.*&quot



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/