Search results for query: *

I', plan to move from the VFP database to MSSQL server. But i have few question before i move to MSSQL server. In VFP i used to write my single file maintainance program in a form with a pageframe with 2 pages. In page 1 contain a grid which is use to display the entire table's record. In here...

I still not every clear about Try..Catch..Finally Can i just put my error handling stuff in the object.error? Like example below : in oApp.error LPARAMETERS nError, cMethod, nLine DO CASE CASE nError = 1 &&In here i will try DO xxxxx &&to put all possible CASE nError =...

Hi everybody, here are some tips sharing. So lets try to post our most frequnce use tips here. I think this kinda tips is very useful for beginer like me: USE EVALUATE OR () instread of & (MACRO ASSIGN) CREATE CURSOR t (cText C(3),nNumeric N(4),cText2 C(3)) INSERT INTO T...

My colleague is developing a VB program to work concurrent with my current VFP program. In my program i use to use rlock() to lock a record (reserve a record,sound stupid but is user request). Now my friend want to determine or lock a vfp table record from his VB program. So i suggest he use...

My colleague is developing a VB program to work concurrent with my current VFP program. In my program i use to use rlock() to lock a record (reserve a record,sound stupid but is user request). Now my friend want to determine or lock a vfp table record from his VB program. So i suggest he use...

Is it possible to find out a record is lock by rlock()in VFP From VB. My colleague is try to write an VB apllication to share table with my current VFP program. but he can't determine the record is it rlock by the vfp. Can some body give some comment ?

When should i use SCATTER NAME ? and what is the benifit to scatter the record data to an object ? Because i still quite new to VFP, so please some body give me some advice. thanks

From VFP Document : SYS(602) - Bitmap Configuration However, off-screen bitmaps use a lot of memory, so you can improve performance on Terminal Server applications by turning these bitmaps off using SYS(602). SYS(602,1) &&(Default) Is this mean by default VFP application will take up lot...

tableA Index tagA : loc + row tableB Index tagB : ali + abu SELECT a.slipno,a.procod,a.lotnum,; RECNO() as rec_no,; a.curcod, b.abu FROM tableA a, tableB b; INTO CURSOR tmplot READWRITE; WHERE loc + row =; cLoc AND ali + abu =; c_sting with...

How do i know that a table is empty ? "Empty" i mean here is no record in tha table or the table contain only deleted record. Does line below work ? nRecno = IIF(NOT EOF("table") OR; BOF("table"),RECNO("table"),.F.) IF TYPE("nRecNo")...

in A form i have 3 textbox, text1,text2,text3. And my code as below : for i =1 to 3 cObject = "text"+str(i,1) cMsg = "ERR_MSG"+STR(i,1)+"_LOC" With &cObject IF .value <= 0 MESSAGEBOX(&cMSG,0+48,ERR_TTL_LOC) .SetFocus()...

I've create a form with 2 combo box.In this form i use only one table. And i set : combobox.rowsource = cAlias.FieldA combobox.rowsourceType = 6 in the combox1 valid method i write : SELE cAlias SET FILTER TO cAlias.Fielda = thisform.combo1.value The problem is when i click on the combo2...

Can anyone show me the some example on implementing EMPTY class ? Is it possible to add an "EMPTY CLASS" to a form and act as a public variable ?

I got i one entry from which is set to modeless. When user add record, another form which is set to modal is call by the modeless form from a textbox valid event. When i click the save button in the modal form. An erros message come out. cannot call set focus from within a...

In the Valid event of a textbox i put code below : IF EOF("t_ireqd") AND EMPTY(t_ireqd.procod) AND; LASTKEY() = 13 SELECT t_ireqd APPEND BLANK oapp.doform("bhpurinb",thisform.DataSessionId) ENDIF The LASTKEY() = 13 is try avoid the form popup if user is in the...

WAIT WINDOW LASTKEY() WAIT WINDOW LASTKEY() TIMEOUT 2 CLEAR TYPEAHEAD WAIT WINDOW LASTKEY() during excuting line 1 i press enter, so in line 2 i'll see a "13". But on line 4 i still see "13". Is it possible to clear the value in lastkey() ?

I'm new to JavaScript. So can any one please explain line below for me? Thanks. var re = /^[a-zA-Z0-9]{1}[a-zA-Z0-9\-\._]+\@{1}[a-zA-Z0-9\-\._]+\.{1}[a-zA-Z0-9\-\._]+[a-zA-Z0-9]{1}$/ ^[a-zA-Z0-9]{1} Mean First character must be between "a-z" or "A-Z" or "0-9&quot...

Is it possible to pass a variable from a form to report ? I try declare a public variable. And then from the report access the variable. It work. But does it have other way ?

For example below ... Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") colItems = objWMIService.ExecQuery("Select * from Win32_CommandLineAccess",,48) For Each objItem in colItems ?"Caption: " + objItem.Caption...

Some time we need to display set of query result in a grid. Usually we use : method A SELECT columns WHERE condition INTO CURSOR cursorname But i used to : method B USE tableA IN SELE(1) USE tableA AGAIN ALIAS resultset SET FILTER .F. ... ... &&Then user type the condition in the textbox...