Recent content by sqlpro

Hi Nathan how do i get total no of tasks of a client in another col i mean if u take abv example client,Category,No.ofRequests,CompletedTasks,UncompletedTasks,allrequests Micrsosft,bugs,10,8,2,10 IBM,finance,22,0,22,23(here this 22+1) IBM,fixes,1,1,0,23 like that bcoz i wanted to keep the...

Yes,Mike u r right in ur opinion.we have some tables that can b very huge.and also we've some clients who cannot pay full sql server license.so we r thinking of splitting databases ofcourse mostly for overcoming 2gb limit. One of the important reasons we moving to sql server is corruption in...

Thank you very much Nathan. Thats exactly what i am after :-) cheers

Thanks Nathan actually i want count of Yes and count of Nos for example say the output col are client,Category,No.ofRequests,CompletedTasks,UncompletedTasks and data is Micrsosft,bugs,10,8,2 IBM,finance,22,0,22 IBM,fixes,1,1,0 Hope i am clear. Thanks cheers

Hi friends The following query returns list of our cliens requests (categorywise we mark each each client request under a category for example finance,accounts,bugs etc.,), category,total no of requests SELECT ClientGroup.fk_clientid, Client.cl_name, Task.fk_catid, Category.Catname...

Hi friends need idea on database design we are moving our application from foxpro database to sql server. we decided that we'd using MSDE for some clients as they cannot efford a full sql server license. we have our data categorized in 3 types. 1)Client 2)our company specific 3)System-Lookup...

Thanks Brian That is very useful link :-) cheers

No Craig i finally endedup taking files into a text file(using List())and creating a cursor from that text file. cheers

actually i thought of that. what if i dont know the extension of files that exist in the folder? how can i specify that i want only first 10,000 files then next 10,000 like that... Thanks for ideas :-) cheers

Hi danceman Thanks for the post. No i did not try mapped drive. actually i'm think the problem is with no of files. if the folder contains only 10000 files then abv command works perfectly if it exceeds 12000 then i get abv error. i am wondering how to get around that cheers

Hi friends i am getting an error with following command lntot=ADIR(x,'\\ben\C\Vip_versions\tstnzgp\doc\*.*') error is Invalid subscript reference actually abv folder contains around 14000 files. is there any workaround for this? Thanks cheers

Thanks Malcolm Thats what i finally decided :-) cheers

Yes,Craig Now we r using Installshield for VFP8 application. Thanks :-) cheers

It seems we finally got it working. we copied following files from our vfp8 runtime and registered them on our client machine RICHED.dll riched20.dll riched32.dll RTFWRAP.ocx (this is actually our activex control) only thing is we copied these files our application installation directory and...

Hi friends i am having problem with a control (richtextbox)in runtime on WINXP os. it is giving error like "Ole error code 0x80007000e:Not enough storage is available to complete this operation" actually we created a activex control in vb and using it foxpro. funny thing is it happens...