Recent content by warik

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

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

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

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.

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

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

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.

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.

Dear all, What SELECT is the best for this sorting problem? table mytable: No | Name | ID 1 | aaa | 20 2 | bbb | 90 3 | ccc | 80 4 | ddd | 10 I would 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 |...

Dear all, What SELECT is the best for this sorting problem? table mytable: No | Name | ID 1 | aaa | 20 2 | bbb | 90 3 | ccc | 80 4 | ddd | 10 I would 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 |...

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

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

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

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

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