Search results for query: *

Hi, I'm curious is there anything i can do such as applying the codes below in a loop rather than what i've used below ? Most of the codes are identical except the cursor name and a condition. Imagine i have 10 cursors. I wouldn't want to replicate the codes 10 times. strText = '' SELECT...

Mike, Many thanks.

Mike, Yeap, that will work. Should i send all the output at once before print or print line by line ? Example : SET PRINTER TO NAME \\U001152\kitchen(1) xxxxxxxxxxxxx <--- print 10 lines. yyyyyyyyyyyyy <-- cut paper SET PRINTER TO OR SET PRINTER TO NAME \\U001152\kitchen(1)...

Mike, Still no luck, unfortunately. Thanks

Alright, i solved the ejecting problem. Now, i have a doubt is my approach is correct when using ??? Example : SET PRINTER TO NAME \\U001152\kitchen(1) <-- set printer ??? "TESTING" + CHR(13)+CHR(10) <--- not printing yet ??? CHR(27) + "i" <--- not printing yet SET...

I just had a go with ???. Working fine except that the page still scroll after printing a line. Example : SET PRINTER TO NAME \\U001152\kitchen(1) ??? "testing" The result : "Testing" word was printing and followed by at least 40 empty lines along. Any idea ?

Hi, I'm doing a new system using Foxpro 8 which is printing receipt using a POS printer. However, i encouter 2 problems : 1) Every printing ends with a big gaps ending up almost an A4 size length. What paper size should i set ? The receipt paper is 76x76x12 2) I unable to cut the paper. I'm...

Hi, Can anyone tell me how to know whether a field in the table exist or not ? Thanks

Geoff, I had a go with ur appoarch, yes, it works for now. Just curious, if i use your suggestion, there is no way system to accept [] as part of the string, right ? lcPhrase = [He said "I'm hungry]"] <-- system don't like this one. Thanks

Hi, I'm trying to execute a SP with parameters. All work fine until i put a ' or a " as part of the input field. Example: SQLStmt = "EXEC sp_master_no @acc_no = '3000/001'," + '@name = ' + "'" + Thisform.s_name.value + "'" EXEC(1,SQLStmt) <-- Will fail if user key-in ' or " as part of the...

hneal98, I'm intending to purely use SP for all SQL statement. Therefore, there will be no inline SQL statament in my application. This mean sp will gonna contains all the SQL DML operation. However, if u suggest 1 SP would be sufficient, How to achieve that ? Example : 1) Update Cust Set...

Hi experts, I'm starting a project using Foxpro with MSSQL database. FOR MSSQL side, i'm now in the middle of creating stored-procedures. My question is should i write 1 single generic Update sp (if possible) or I have to write diffrent sp for all different FROM and WHERE clause. B'cos the...

Hi, I'm a beginner in MSSQL. When i convert from char to varchar in the table, i noticed that by default varchar is using 50 length. What would be the impact in term of space consumption if i leave it as 50 althought i only need 10 since varchar is in variable length. What i'm think is, if...

Mike, Thanks for your swift response. Yeap, I missed out the Error checking. Thanks for reminding me. I have 1 questions after reading ur reply, if u don't mind. Is there a cursor created when there is no record selected in the SQLEXEC() ? I tried in my office (command window), i created an...

I'm doing conversion from vfp to MSSQL database. When i get my hand dirty yesterday changing a screen, i'm really worry whether am i doing it a right way although it's functionally works. Because this scrren i was doing has nagivation buttons (Top,Prev,Next,Last), I decided to select the whole...

I developed 2-tiers accouting system using Foxpro with VFP native tables. Now, I'm thinking of extending it to talk to MSSQL server. I was planning to use SPT but then I came across a class called CursorAdapter. My question is which one should i use for minimum work. CursorAdapter sounds...

Thanks guys. With all your help, it finally works. Once again, Thank you.

Jim, Unfortunately, by applying do form search_form WITH "'H','L'", i am now have no record selected. Thanks

hi, I'm stuck in trying to pass in a parameter below do form search_form WITH 'H,L' All the time,i pass in 1 character, but this time, i need to make it cater for more. In my search_form (Init Method): LPARAMETER w_special_acc <----- will receive H,L thisform.grid1.recordsource = 'Select...

Experts, From day 1 when i use Foxpro, i know its database engine is very fast. However, when people heard of Foxpro database, they look down on it. All in their mind is MSSQL. I'm pondering, if Foxpro database engine is so fast and powerful, then why people use MSSQL as the back-end for...