Search results for query: *

Thanks Rick :)

What datatype in MS SQL equivalent to char(bin) in VFP ? I want to maintain character data without change across code pages. TIA.

There is no error. But when I browse the table, I could not find the new record.

Hi all, My problem is I can not add record to a table. Actually, I add new record in my form and this form use view which go to the table. First, I guess that it's index problem. Therefore, I pack and reindex the table but it didn't solve the problem. Then, I try insert sql command. After...

Try this ? ROUND(1219.000000*3.795,2) = 4626.11 ? ROUND(1219.000000*3.7950,2) = 4626.10 ? ROUND(1219.000000*ROUND(3.7950,4),2) = 4626.10 ? ROUND(ROUND(1219.000000,4)*ROUND(3.7950,4),2) = 4626.11 The result should be 4626.105 and round(4626.105,2) = 4626.11. Any idea ? TIA

Hi all , I want to zap all user table. How can I write store procedure to do this job ? TIA.

Thanks Leland, I will give it a try :) Thanks Andrea

I have cursor in VFP (cr_item) Then with VFP table I can do this select itemno, itemdesc from itemmaster where itemno not in (select itemno from cr_item) But if itemmaster is table in MS SQL, how can I do it with SPT ? TIA

Hi all, I just wonder about currency and numeric field type. Just try.... ? 41379 * 0.36099 the result is 14937.40521 but... ? NTOM(41379) * 0.36099 the result is 14937.8190 How come ? TIA

Hi all, When I install SQL2k Personal Edition on W2kPro, it failed. I see the log file and see [Microsoft][ODBc SQL Server Driver][Shared Memory] Encryption not supported on SQL Server When I create DSN on this W2Kpro to connect to SQL database on other server, it also shows the same error...

Thanks all for responses. I found another function that can apply this SELECT itemno,description FROM mytable WHERE charindex(class, 'A B C') <> 0 remark : class is char(1)

Hi all, I am VFP programmer and looking for operator in MS SQL 2000 that work like $ in foxpro. For example : In VFP, I can do like this.... select itemno, description from mytable where class $ &quot;A B C&quot; but how can I do in MS SQL. TIA. Thongchai

Thanks for quick response. I am VFP programmer. What I am trying to do is create a View which criteria is variable, such like VFP view. How can I do it in store procedure? Would you please guide me ?

Hi all, I am new for SQL2000. I want to create view with parameter. How can I do? TIA