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!

  • Congratulations bkrike 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: astech
  • Content: Threads
  • Order by date
  1. astech

    unique data from two tables

    Hi all, 1. what is the default of empty datetime format ? 2. eg. I have 2 tables TableA( id c(6)) and TableB( id c(6)). Unique id format is like 'A99999' How to make an unique id from combining of that two tables, so there is not an duplicate id from both tables ? Thanks
  2. astech

    TextBox Manipulation

    Hi All, I have confuse with textbox focus. I already set format with K, and the meaning when cursor go to the textbox, it's will be block and when i type anything, it will be replaced with the new entry. But when the textbox clicking by mouse the K format is ignored. and the meaning when i type...
  3. astech

    How to fast table combine

    Hi All, i have 2 table with same fieldname tableA (code c(7)) and tableB (code c(7)) tableA has 500,000 records from 'A000000' to 'A500000' and tableB has 400,000 records from 'A500001' to 'A900001' How to fast combining both table in a corsor and knowing max code record ? Thanks for help.
  4. astech

    Disabling Numeric Round

    Hi all, I have a total value as 88.6840 but it's save as 88.6800. I already to set decimal to 4. any advice, please ?, cause i absolutely forget to handle this problem. Thanks
  5. astech

    export DBC/DBF to MSSQL or MYSQL

    Any body know how to do that, or any softwares can do that ? thanks
  6. astech

    Identifying field type

    I have a table with fields like : TableA Field1 C 10 Field2 N 7,2 Field3 D 8 How do i identify all field types and widths and decimals with a programaticly. thanks for all advices.
  7. astech

    sharing folder protect

    i have a shared folder named Folder1. and have create 3 users (A, B, and C). eg. Folder1 (sharing name is public1) = public folder |_ Folder2 (allowed to user A only) |_ Folder3 (allowed to user B only) |_ Folder4 (allowed to user C only) How to setting like that. Sorry, i just a...
  8. astech

    using an array

    i have parameter named pUser. pUser = 'UserA,UserB,UserC,UserD' can i break it to array to be : array(1)='UserA' array(2)='UserB' array(3)='UserC' array(4)='UserD' can you help me, please ...
  9. astech

    Fill grid automaticly

    I have a class form with a grid inside, so how can i fill the grid automaticly with a table selected, after created a form with that class form.
  10. astech

    Understanding of Command Button Click()

    In commandbutton.click(),Stored : cxKode=Space(6) do form formtwo * Command must stop here and do bellow after formtwo closed * or running until "endif" then stop ? If not empty(cxkode) ...... Endif * If it stop after "do form", why my button is stop after "endif&quot...
  11. astech

    Relation missing

    i put this code in load form: USE (thisform.mstdata) IN 0 ORDER(thisform.mstorder) shared SELECT (thisform.mstdata) USE (thisform.dtldata) IN 0 ORDER(thisform.dtlorder) shared SELECT (thisform.dtldata) SELECT (thisform.mstdata) SET RELATION TO (thisform.mstorder) INTO (thisform.dtldata) addi...
  12. astech

    Form variable / Increamental search 2

    I have a form with 1 grid and 1 textbox, In the form, created 4 property : tnmtable,tnmdata,tkdData,tfind. Table in Use: Tblgroup (ckdGroup,cNmGroup) Form1.tnmtable=Tblgroup Form1.tnmdata=cNmGroup Form1.tKdData=cKdGroup in Form.init wrote : ************************** SELECT...
  13. astech

    Incremental Search

    I have one from and one textbox and one grid. how to filter grid with value that i input in textbox ?
  14. astech

    Dropdown ComboBox

    How to dropdown combobox using keyboard (without clicking mouse)?
  15. astech

    data cannot change in server

    I create program and it's work in my pc,but when i post in in server the data cannot update. the server connection is good, and database path is ok. the list is : CURSORSETPROP('buffering',5,'tblPrice') cxKdReal=MstCst.cKdReal cxKdTmp=MstCst.cKdCst SELECT tblPrice replace ALL ckdcst WITH...
  16. astech

    Very fast data connection

    Hi all Expert, I have much question that confusing me. It's about very fast and best data connection to include in my project. 1. What database to used (DBF,Access,SQL,Oracle or etc) ? 2. What connection to used ? 3. What a Trick to fast in using it ? 4. How to using in multiple user used it...
  17. astech

    Select SQL without Data

    How to using Select SQL without data copying ?. Thanks.
  18. astech

    RemoveListItem Help

    How to use RemoveListItem in list property. I'm not found it on the sample in VFP 8 help.
  19. astech

    OS Manipulate

    How can I know what the OS of my PC in VFP 8(XP,Win2000,Win2000 Server,Win 98) ?. Thanks.
  20. astech

    pack database

    Is pack database including pack tables inside ?. How to pack tables in database programaticaly ?. thanks.

Part and Inventory Search

Back
Top