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

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

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

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

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

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

Hi, I came across an error when i try to create a directory which contain a space. Example w_path = "c:\Program Files\ABC" MD &w_path <-- this will only create a folder called PROGRAM Does anyone has a clue why ? Thanks

Hi, Just a very simple question. How can i extract the TIME from a datetime variable ? Thanks.

Hi, I have a class declaration as follows: DEFINE CLASS C24x7 AS Custom OLEPUBLIC .. .. some codes here .. ENDDEFINE But, when i try to instanciate to objects from this class on command window, o = CREATEOBJECT("Uniware.Pay24x7.C24x7") <-- ok b = CREATEOBJECT("Uniware.Pay24x7.C24x7") <--...

Hi, Usually, I use the USED() command to detect any opened table. Normally, i works fine until this new project. When a tbale was open exclusive WHAT I DID : 1) issued "USE 'c:\VisDev\Figures\Data\' + 'us_user'" from another Foxpro command window 2) In another foxpro, i run the codes...

I'm writting a COM object and i come across that i can't define setting at the Class level DEFINE CLASS C24x7 AS SESSION OLEPUBLIC SET DATE TO BRITISH <----- error DBPATH='c:\VisDev\Figures\Data' p_lstdte={31/12/2100} p_comp="001" FUNCTION ...

Hi, As i'm developing my COM Server, i have a function that needs to return a result in XML format. I don't need the physical XML file anyway. But, I have no knowledge of accomplished this. All i got was i managed to output the result to an XML phisical file. My codes : SELECT us_userid dob...

Hi, can anyone advice me what function can i use to get the number of lines in a txt file ? Thanks in advance.

I'm doing a project that my colleuge has written a window services that need to talk to my Foxpro application's fvp database. He suggested COM object to me. I have no knowledge about developing COM object using Foxpro. Can anyone point me a direction to start ? Is COM object the most easiet...

Hi, I'm trying to execute a DO statement as follows : DO check_status WITH 'T' However, my check_stauts.prg has a RETURN statement. How can i able to 'read' the return result from my prg program ? Many thanks

Just curious is there a way "in foxpro" to know who else login my database application beside myself ? I'm using Vfp 8 with foxpro database. All i can think of now is usinf a free table, u_trace(usr_id,loginCnt). Everytime user login, update it based of the userid and +1 for login_cnt. If user...