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

    How INSERT numeric from textbox?

    You right Mike, I have to write all my coe for this problem. I would like to use it at my SQLEXEC function. This is all code: NumRows = SQLEXEC(myConnection, "insert into mydata (name,old) values ('"+thisform.name.value+"',"+thisform.old.value+")", 'MyCursor2')...
  2. warik

    How INSERT numeric from textbox?

    kilroy & bon011, sorry forgot to tell you that the mydata structure is: name char(20) old num(3) So I cannot use str() at this problem. Maybe someone could help me? Thank's in advance
  3. warik

    How INSERT numeric from textbox?

    This is the problem: I have 2 textbox, lets say name (char) and old (int). When I want to insert is value to SQL, I have a problem, and it said Operator/operand type mismatch. I use this code to do that: INSERT INTO mydata (name,old) VALUES...
  4. warik

    MySQL Grid Problem?

    Yes Mike, you right with make a temporary cursor and copy all data to it will be keep the grid setting. Thank you very much, your help and your link for sample is really great and it solved my problem.
  5. warik

    MySQL Grid Problem?

    Hi, I make a MyODBC (MySQL) to write down table to grid with this code: NumRows = SQLEXEC(myConnection, "select Mailbox from coba", 'MyCursor') ThisForm.Grid1.RecordSource= "mycursor" But If I modified that table value (delete or Add record), I have to refresh the grid...
  6. warik

    Grid costumize Procedure

    This is sample of my grid property: ThisForm.Grid1.ColumnCount=6 ThisForm.Grid1.RecordSource='wla' ThisForm.Grid1.Column1.Width=40 ThisForm.Grid1.Column1.Header1.Caption='My Field' The problem is, I would like to take some code at DoubleClick event at column1, Can I do that except write it at...
  7. warik

    Sorting Problem

    Thank you sleipnir214 for your answer. I thought this problem also can be solved with php script except MySQL itselft. Anyway... thank's a lot.
  8. warik

    MySQL Sorting Problem

    Thank you sleipnir214 for your answer. I thought this problem also can be solved with php script except MySQL itselft. So I wrote at PHP Forum and MySQL Forum. Anyway... thank's a lot.
  9. warik

    Sorting Problem

    ...like to sort become like this : Sort from name, but ID 90 will be the last. So it will be like this: No | Name | ID 1 | aaa | 20 3 | ccc | 80 4 | ddd | 10 2 | bbb | 90 What I know to sort name with: select * from mytable order by name..... what next? or any other advice? Thank you in...
    • warik
    • Thread
    • Replies: 3
    • Forum: PHP
  10. warik

    MySQL Sorting Problem

    ...like to sort become like this : Sort from name, but ID 90 will be the last. So it will be like this: No | Name | ID 1 | aaa | 20 3 | ccc | 80 4 | ddd | 10 2 | bbb | 90 What I know to sort name with: select * from mytable order by name..... what next? or any other advice? Thank you in...
    • warik
    • Thread
    • Replies: 3
    • Forum: MySQL
  11. warik

    Can I change Computer Name at W2K Domain Controller?

    Yes, It work... After demote with dcpromo and choose 'This server is the last domain controller in the domain' then follow the next step, I could demote the domain controller, restart. Then change the computer name. After finish changing the computer name, I start Active Directory again from...
  12. warik

    Can I make my own user right?

    Dear all, At native XP, there are a lot off group such as Administrator, Poweruser, User, etc. Well, How do I make a new user group with my own right. Let say I make group 'owngroup' And this group will only have access to 1. run some program 2. edit registry at some registry place (at...
  13. warik

    Can not show Help when pressing F1

    Dear all, First time I setup WinXP Prof SP1a, I still could use help file when pressing F1. I don't know why, it can not happen again now. Even the first time I booting and start the XP, the help file still can not load when pressing F1. Maybe someone could help me solving this problem. Plz...
  14. warik

    Can I change Computer Name at W2K Domain Controller?

    How to demote DC? I've been trying with dcpromo and it appear Active Directory Installation Wizard, and if I follow the instruction (until second step), it seem to make new Active Directory like what I did before (at the first time I made the domain controller with wrong computer number). Plz...
  15. warik

    Can I change Computer Name at W2K Domain Controller?

    Dear all, Can I change Computer Name at W2K Domain Controller Server? If it can, how should I do that? Thank you in advance
  16. warik

    How to deny list/browse drive C:

    bcastner, I use NTFS, but if I disable for list folder, it also disable to execute the program inside it. How to make even disable for list folder but still execute the program at that folder. Teammaker, I user Windows XP Prof, and I create at it's own security setting. My computer is not...
  17. warik

    How to deny list/browse drive C:

    Dear all, I would like to make user account which can not browse/list drive C: and it's directory, but that account still could execute or running a program from it. What Security access do I have to set? I ever try for deny account to read drive C:, but that account can not run photoshop...
  18. warik

    Cursor question

    Yes Monikai and Mike, now I understand how to use the cursor at my probelem. And also thank's for your point. Thank you very much for you all
  19. warik

    Cursor question

    Monikai and Mike, if I'm not wrong, what you are doing is counting mycursor record, but it's ok too for me. Well, let me change the question. My problem with something like this : a=1 use mytable && contain: number,name field set order to number seek(a) if found() iname=name...
  20. warik

    Cursor question

    ...field set order to number seek(a) if found() messagebox("found it") else messagebox("nope") endi what I already done : a=1 select * from mytable where number=a into my cursor than what shuld I do next with the cursor mycursor? I use VFP5 Thank you in advance

Part and Inventory Search

Back
Top