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

    unique data from two tables

    Thanks for all your kindess to help me. Sorry, i'm just dummy.
  2. astech

    unique data from two tables

    Thanks Mr. Ramani for your solution. May be my mistake, is in not using lock. how about this way below ? My reason is we adding new data when idTable is in Lock. where is the best way like the first. IF RLOCK('idTable') myNextId = idTable.IdNo REPLACE idTable.IdNo WITH myNextId+1...
  3. astech

    unique data from two tables

    Thnks Mr. Ramani, this is my clearly of my question. I have 2 tables named TrxAir and TrxSea. In the Transaction I have 2 Forms like : Form "Air Transaction" using Table TrxAir and "Sea Transaction" using TrxSea. this is my listing. *** Info...
  4. 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
  5. 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...
  6. 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.
  7. astech

    Disabling Numeric Round

    Yes, you're right, i don't know why but now it's done. thanks to all of you. Thanks, Barbara Peisch
  8. astech

    Disabling Numeric Round

    here's the code : Local cConsole cConsole = SET("CONSOLE") SET CONSOLE OFF SELECT DtlMawb WITH Thisform.pfm.pgd CALCULATE SUM(DtlMawb.ngrossout) ; FOR HdrMawb.cnomawb = .txtcnomawb.Value AND NOT DELETED(); TO .txtnaGrossout.Value...
  9. astech

    Disabling Numeric Round

    saved on field.
  10. 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
  11. astech

    export DBC/DBF to MSSQL or MYSQL

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

    Identifying field type

    Thanks for your advices. But can i know it without an array, i just wanna take a part of field. like checking only : Field2 N 7,2
  13. 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.
  14. 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...
  15. astech

    using an array

    thanks, Mr. jimmo
  16. 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 ...
  17. astech

    Fill grid automaticly

    Thanks for your advice Mr.craigsboyd, But it will show all field in grid. here i mean : with that classform, i create 2 forms : FromName :FormA Table :TableA (Kode,Name,Address,phone,email) Field use: Kode,Name,phone,email FromName :FormB Table :TableB (Kode,Name,Address,phone,email)...
  18. 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.
  19. astech

    Understanding of Command Button Click()

    thanks slighthaze
  20. 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...

Part and Inventory Search

Back
Top