Search results for query: *

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

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

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

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

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

Can I do this with SQL? a=1 use mytable && contain: number,name 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...