Recent content by creedprg

Hello guys Problem has been solve by using "From : &varfrom_time" ; + '%0D%0A'; +"To : &varto_time"; + '%0D%0A'; It works perfectly... thanks guys.

i tried to search any code to put a line feed in ms outlook message body. the out put should be like this: Time start : 09:00 time end : 12:00 but when i tried to put it on outlook body it will look like this : Time start : 09:00 time end : 12:00 it tried chr(13) + chr(10) but it didn't...

Hello masters thank you for all the response on this thread. i finally got the solution to this. the idea is to transfer the data from my dbf table to excel file yet in a different format, the records become the field(header in excel). Mike was right it i have to limit the record in order to...

Hello guys. I would like to create an cursor from my original table the problem is it has different structure. my original table look like this. modelno defect_type qty test1 scratch 10 test2 dent 5 test3...

Hello Guys i am trying to create a output my table in a different format. It shows like this this is the original format of my table original table Modelno....defect_type......qty test1.......scratch..........10 test2.......dent.............12 test3.......deform...........20...

Hello Guys is there any way to extract date from DATETTIME field in SQL sever? In visual foxpro i just issue a command using TTOD(Datetime()) but in MS SQL this TTOD function is not supported, May i know some equivalent command for this function.... Thank you in advance.

[bigears] thank you so much guys... this is a big help Highly appreciated problem solved. thanks mike and olaf :-)

Hello everyone, im having problem with this select statement, whenever i put my select statement inside the quotation i encounter problem it says unrecognized command. is there any limitation in select statement when i put it inside the quotation mark? here is my example of code. i always...

Ok I understand. i am now working with the samples given by sir olaf. thanks

@mikelewis i really don't have an idea how does it work.[sad]

Hello Guys, I need some sample of how to use parameters and it's function. Thanks JEss

@Mike Lewis (Edinburgh, Scotland) thanks for help sir, problem has been solved by following your given instruction "SELECT Name, ID, ... FROM Test.dbo.Customer " I have specified the database where the table is stored. Thank you so much!!!! jess

ok... im using MS SQL as my back end database installed in my 2003 server. on my Pc i have 2 odbc driver odbc1 connect to database1 and odbc2 connect to database2. I wish to access this two database in one form. is it possible?

Hello Guys; I'de like to use 2 ODBC driver in on form, the logic is that to access different database. thanks

Good day everyone. Can any one tell me what software can open .DDB file. thanks