Recent content by sarklow

I think because SELECT does not recognise VFP tags. Try SELECT INTO ORDER BY .... If you want to generalise then lcTag = TAG (table) SELECT .. INTO ... ORDER BY &lcTag

Hi Shy, Try ... DECLARE GetVolumeInformation IN win32api STRING, STRING @, INTEGER, INTEGER @, INTEGER @, INTEGER @, STRING @, INTEGER LOCAL ; lcFileSystemName, ; lcRootPath, ; lcVolname, ; lnFileSystemFlags, ; lnFsnameLen, ; lnMaxFileNameLen, ; lnVolNameLen, ; lnVolumeSerialNumber...

Hello, You would appear to be always selecting the first item in the approval_list and your DO WHILE condition will always be true. After you have added the item to the agenda_list you need to move an index on or wrap the code with a FOR loop up to the number of approval_list.ListCount ? Hope...

Hi Stewart A reflexive join exists when a table is joined to itself through a second column. For example, the table Employee(EmployeeID,...,ManagerID)could have a join from ManagerID to EmployeeID.

Hi, Yes. SET commands are scoped to the current datasession. Perhaps stick a call to a SetSets() module in your form Load().

Hi In the INIT of FORM2 LPARAMETERS lcParm1 * Check the presence of the parameters and whether they * have the expected type. * * If ok then assign to form property. * IF VARTYPE (lcParm1) = 'C' Thisform.cValue = lcParm1 ELSE Thisform.cValue = '' * * And any error reporting code...

Hi, As I understand it you are trying to relate two different values from one Contract record to different records in the User table. Although you can logically set this up in the DE I what I think will happen is that the record pointer in the User table will settle on the record which matches...

Thisform.Refresh()

Hi, EditBox.ReadOnly = .T. should do the trick.

Hi Bebbo, Try using INLIST eg ... FOR INLIST (StkRecord.Dept,'01','03','06')

Hi, If the Tools Options doesn't work - and it didn't for me - then try this solution from the MSDN which did work for me. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q214560

Hi TheManiac, If you are about to start using classes and sub-classes be aware of a popular gotcha ... ANY text in a sub-class method will prevent the parent class method from firing. This includes a simple space or a comment.