Search results for query: *

Thanks MikeLewis , Your solution worked . The reason i went with Bracket is after searching for Date comparision. What i misssed is that my field is already a date variable. ltr=LTRM2 SELECT * from &TRDB where inpdate > ltr into table temp.dbf where LTRM2 is the date field in the table I...

Thank you all for the reply. The ltr is a dat field only. I am going to test the suggestions and will post you the result.

Hi, I have a problem with the select statement with a Date field in foxpro project SELECT * from &TRDB where inpdate > {ltr} into table temp.dbf use temp.dbf GO BOTTOM @ 2,3 SAY RECNO() I tired SELECT * from &TRDB where inpdate > {^ltr} into table temp.dbf where &TRDB is a table name...

I am trying to develop a web page.In the webpage, i have two radio button. I need to make visible some text fields and labels when one radio button is selected and make other fields invisible. Here is what i have coded <tr> <td width="10%"> </td> <td width="10%" colspan="2"...

Thank you all for the support providing. The code provided by Olaf is working . The index file generated is sale.cdx thought the tag is given as idx1. Is this fine Also if i want to have index on mulitple field, when i tried in single statment like fcn.Execute("Execscript('Use...

Thanks again Mike, You have cleared one of my basic understanding of Indexing

Thanks Mike for the reply I used fcn.Execute("use sale; index on brand tag idx1") This didnt throw any exception. But i am not able to see any index file named idx1 getting generated. Also in table i cannot see the changes getting reflected( i.e the field Brand getting arranged in order)

Sorry, a correction in the error generated "Errors reported by ADO (1) Error#: -2147217900 Desc. : Command is missing required clause. Source: Microsoft OLE DB Provider for Visual FoxPro Native Error: 221 SQL State: Help Context: 0 Help File: "

Thanks for the message. when i used it , i got the following message "Errors reported by ADO (1) Error#: -2147467259 Desc. : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Source: Microsoft OLE DB Provider for ODBC Drivers Native Error: 0 SQL...

I tired with what Mike has suggested fcn = New ADODB.Connection fcn.ConnectionString = "provider=VFPOLEDB.1;Data Source=" & tablefolderpath fcn.Open() fcn.Execute("Index on BRAND tag idx1 ") where tablefolderpath = D:\myfolder In this folder the file named sales.dbf...

I am not able to use INDEX ON command on a linked table. ie, i tried to use cmd = New OleDbCommand("Create INDEX itmno_idx ON INVENT(ITEM_NO) ", cn) But this statement is not supported from vb.net.

Hi all, I am having a foxpro table ( VF6). This is linked in MS access. From a vb.net application, i am reading the values in the foxpro table. Currently the search is taking a long time. So thought about indexing the foxpro table. But from a vb.net application, i am not able to index the...

I will try these solutions :)

My dltemprcd table is a copy of the employee table. ( all the fields are same) Suggested by bborissov, do we need two From from in a select statement. Is this wat is intended SELECT * FROM employee where empid =lclempno INTO TABLE dltemprcd This is not updating the record to dltemprcd table

By using SELECT employee LOCATE FOR EmpID = lclempno ThisForm.refresh I am able block the pop up and then modify the selected record only without affecting the values of first record

I am using VFP6

i want to delete a record from employee table with a specific empid and before deleting , i want to copy all the equivalent data in employee table to another table, deletemprcd. I tried using SELECT * into deletemprcd from employee where empid =lclempno but getting syntax error Here i...

Thanks mike for the suggestion. i have not completly tested the suggestions provided. when i start to test the suggestions, another problem pop up. thats the reason why i have mixed up the questions. I will keep it in mind about the suggestions and will follow the same.

One more bug. I have used cursor as suggested in the prevoius post SELECT civilid,fname,lname,dob,nation,gender,married,contactno,doj,salary,commision,division,empsnap,address; from employee where empid=lclempno into cursor mycursor Suppose i have 5 record, and i am searching for 5th...

I want to delete a record from a table and the deleted record has to be copied to another table. I tried using SELECT * into deletemprcd from employee where empid =lclempno but getting syntax error Here i want to delete a record from employee table with a specific empid and before...