Recent content by ilyad

The SQL seems correct to me. Are you sure both fields are of the same type and length? Another way to get the same result is: select fg.contact, fg.LastName from final_aig fg left join aig_errors ae on fg.contact = ae.contact where ae.contact is NULL order by fg.lastname

See also http://www.berezniker.com/display/VFP/Enumerate+Available+Drives

I certainly will, thanks a lot again. Haven't time today to look very closely, will read on Sunday.

Hi Pamela, Just looking at the code you posted, where do you use the API? To get the number of logical drives? But you're not using this number in the code bellow.

Apart from others' ideas I think you're probably moving focus out of the grid and thus lots of other extra events occurring. Marcia Akins posted a way to validate records in a grid on a different web-site.

Tamar, Thanks a lot for the link to your paper. I'll study it in details tomorrow, but I have to admit, I didn't know about nested joins. I always use JOIN with ON condition following right away.

Hi Bryan, To console you a bit I've seen some Debugger problems and even posted a thread on another forum about it. The thread then turned into a complete joke starting with "Now we're in trouble. If there's a bug in Debugger how are we suppouse to debug it with Debugger that has bug in it?" :)...

I think you should use LIKE instead of =

Also how many files in this directory already? Try to move them to another place.

Did you try to defrag this drive?

Usuaally the first error indicates some network failure. Are you writting this file on the Network? What kind of Network do you have - NT or Novell? So I agree with dgrewe here. Make sure the file is not opened with the same name.

In the code that does the assignation simply add code I posted as the last line. Or you can use SelLength approach as shown by others, but then you would need to pass an object reference to your editbox into the procedure.

Try keyboard '{Ctrl + End}'

Olaf, :) Yes, it would be nice to have Salary = SSN :)

I'll try to play with AllowCellSelection property. In this particular form I can not really move editbox out of the grid, though, of course, for editing I have an Editbox on the form. I may try to use only first 250 chars instead and replace editboxes back with textboxes in the grid. I'm afraid...