Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: makdu
  • Order by date
  1. makdu

    Problem with select Statment in Foxpro project

    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...
  2. makdu

    Problem with select Statment in Foxpro project

    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.
  3. makdu

    Problem with select Statment in Foxpro project

    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...
  4. makdu

    Radio button usage in struts

    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"...
  5. makdu

    Using index of foxpro from vb.net

    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...
  6. makdu

    Using index of foxpro from vb.net

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

    Using index of foxpro from vb.net

    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)
  8. makdu

    Using index of foxpro from vb.net

    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: "
  9. makdu

    Using index of foxpro from vb.net

    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...
  10. makdu

    Using index of foxpro from vb.net

    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...
  11. makdu

    Using index of foxpro from vb.net

    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.
  12. makdu

    Using index of foxpro 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...
  13. makdu

    copy table content using select * into

    I will try these solutions :)
  14. makdu

    copy table content using select * into

    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
  15. makdu

    Block pop up from select statment

    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
  16. makdu

    copy table content using select * into

    I am using VFP6
  17. makdu

    copy table content using select * into

    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...
  18. makdu

    Block pop up from select statment

    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.
  19. makdu

    Block pop up from select statment

    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...
  20. makdu

    Block pop up from select statment

    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...

Part and Inventory Search

Back
Top