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 Chriss Miller 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: gchandrujs
  • Order by date
  1. gchandrujs

    Visual Foxpro Modifing a field name

    Hi Martylb you can use the below sql statement for what you need alter table tablename rename column colname to newcolname HTH [smile] gchandrujs [sunshine]
  2. gchandrujs

    sql passthrough

    Hi, . So in case there is a poweroutage during the insert process I don't have bad data For that you have to use Transactions or Buffered Tables. BEGIN TRANSACTION SELECT statement... into Cursor Mycursor select Mytable Append from DBF('Mycursor') END TRANSACTION If the power short comes in...
  3. gchandrujs

    Navigation Buttons

    Joe How can i disable the next button when i navigate at 20th record and disable the previous button when i at first record? In the Next Button add SkIP If Eof () SKIP -1 THISFORM.REFRESH () THIS.ENABLED = .F. ENDIF Use the same accordingly in the PREV button. To Enable the Same in the...
  4. gchandrujs

    Navigation Buttons

    Hi Joe, Since the Record pointer in the Beginning & End of the File the controls looks like disabled. So, Use the following conditions before navigating in your command buttons. *** IN THE PREV BUTTON IF NOT BOF () SKIP -1 ENDIF ** IN THE TOP BUTTON IF NOT BOF () GO TOP ENDIF *** IN THE...
  5. gchandrujs

    Hi, I want to know the suitable ev

    Hi, Try using KeyPress Event. But even for Cursor movements between the contents in the combo box this event fires. Otherwise try using VALID event. gchandrujs [sunshine]
  6. gchandrujs

    UPDATE CONFLICT - error

    You have to give either TABLEREVERT(.T.) or TABLEUPDATE(1) to come out from this problem. [smile] gchandrujs [sunshine]
  7. gchandrujs

    Report Form

    Dear Mike, Hope you too understand that FreddyHo may use more than a table for Packing slip too or however if a Invoice may contain Multiple Packing slip It may be not possible to do this in Summary Band. Because In general, he may need just like another Detail Band. This is my lowest...
  8. gchandrujs

    Report Form

    Hi, According to me, it is not possible But can be done in some lengthy way and it should not be faster as you think. So, it is good that let it be in 2 reports. In your programming make the output (preview) of the 2 reports continuously. ie.. REPORT FORM MyInvoice PREVIEW REPORT FORM...
  9. gchandrujs

    Congratulations Mike!

    My Heartiest Congratulations Mike You have helpmed me in many ways and i am remember you always and Many many thanks for your help. [b]Once again wishes to grow in your life,and hope your help continuous to everybody forever [b]Praising the Lord to Bless you[u] GCHANDRUJS [sunshine]
  10. gchandrujs

    Show specific fields in GRID

    Hi, As you told, if you select the rowsource type as "cursor1". Then after in the Refresh Event of the Cursor you write the following. thisform.grid1.setall("VISIBLE",.f.,"Column") THISFORM.GRID1.COLUMN1.VISIBLE = .T. THISFORM.GRID1.COLUMN4.VISIBLE = .T. The...
  11. gchandrujs

    Show specific fields in GRID

    Hi, As you told, if you select the rowsource type as "cursor1". Then after in the Refresh Event of the Cursor you write the following. thisform.grid1.setall("VISIBLE",.f.,"Column") THISFORM.GRID1.COLUMN1.VISIBLE = .T. THISFORM.GRID1.COLUMN4.VISIBLE = .T. The...
  12. gchandrujs

    Dot Matrix Speed Problems.

    To make Generic / Text only, When you install New printer instead of selecting the Exact Manufacture from the list during install, Select GENERIC under Manufacturer list and GENERIC / TEXT only under Models List. This will Helps. If you don't want to reinstall the printer, From the Printer...
  13. gchandrujs

    Question.....

    HI Mike, Where there is need, we have to use somethings. What cjulio done with Where &comando is not wrong. He may in need of that. I can't understand And see if that is the culprit Suggestions Invited... gchandrujs [sunshine]
  14. gchandrujs

    Question.....

    I Think that SQL query Statement takes long time and ATCC too. If you want to know the timings of each line execution try using SET COVERAGE TO filename command before executing the above codes and after finishing codes give SET COVERAGE TO. Now you can view the filename for time taken for...
  15. gchandrujs

    Time Functions

    HI, to add seconds you use give as follows. eg. ?datetime () ?datetime ()+ noofseconds If you want to add a minute ?datetime ()+60 If you want to add an hour ?datetime ()+3600 && (60 Mintues ie. 60 seconds x 60 minutes) Suggestions Invited... gchandrujs [sunshine]
  16. gchandrujs

    calling other forms

    HI Poeijer, If you found any problem with Mike's suggestion, go to the following. FOR I = 1 TO _SCREEN.FORMCOUNT IF _SCREEN.FORMS(I).NAME = "Yourformname" _SCREEN.FORMS(I).TEXT1.VALUE = "TEXT2" ENDIF ENDFOR Anyhow you are not going to run more forms at a...
  17. gchandrujs

    How to display an SQL result into a GRID?

    Ya, that i know why you gone to interactive change mode. Your approach is good but If it is List box no problem As you are using grid there will be delay in time. Anyhow, you create a seperate method which contains the No. of Columns, column widths of the grid, Header captions etc., and in the...
  18. gchandrujs

    How to display an SQL result into a GRID?

    HI, select myCode ; from zz_test ; WHERE myCode LIKE ("%"+UPPER(ALLTRIM(Thisform.text1.text))+"%"); into cursor myCursor After that put THISFORM.LOCKSCREEN = .T. THISFORM.GRID1.RECORDSOURCE = "MYCURSOR" THISFORM.LOCKSCREEN = .F. The above results appear in grid...
  19. gchandrujs

    Optionbutton to return character field

    HI VFP602, You told that the option group is bounded with Character field. So follow the below. Make the value property of one option button as 'AL' and other option button as 'SL' in the option group. And make the option group value property as either one of your value. Hope the above...
  20. gchandrujs

    clear events not working in PRG

    Kenndot I'm trying just to get out of the program altogether when an error is generated As you told when error occurs what are the option buttons that are available with that error. whether CANCEL,SUSPEND,IGNORE, HELP. Check it? this may cancels your program execution further after the...

Part and Inventory Search

Back
Top