Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sqlpro
  • Content: Threads
  • Order by date
  1. sqlpro

    need ideas on count()

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

    need expert opinion on database design

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

    error with Adir()

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

    activex error

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

    web enable

    Hi friends I need ur advice on web enabling our vfp8 application. we have an application (vfp8 front end sql server as backend).It tracks our company tasks and projects etc., we want to web enable this application.I want some idea where to start. I know that we can create a website(using ASP)...
  6. sqlpro

    need idea on shortcut menus

    Hi friends i created a shortcut menu and i added following command in one of menu items _screen.activeform.menu4systray(3) i want to execute a method in activeform but i am getting following error property menu4systray is not found how do i achieve what i want. Thanks for ur ideas. cheers
  7. sqlpro

    ctTree control could not be opened in design mode

    Hi friends has anyone used ctTree control? I am having problem with Cttree control(www.dbi-tech.com) when i am trying add control on a form i get following message like "CLASS NOT REGISTERED" but previously we created this control exclusively through code and having no problems but now i am...
  8. sqlpro

    facing same problem as LotusE99 with systray class

    Hi Lotuse99 I am having same problem as u did when using systray class thread184-805792 in my case i am not using any timer for menu items. i simply filled property menutext like .... 1;Restore Tracker;2;Stop Work Time;3;Start Work Time;4;Exit Tracker it works couple of times after that it...
  9. sqlpro

    lotempform error while using systray class

    Hi friends i am trying use systray.vcx in our application.i copied systray.vcx from its HOME() directory to our application folder i followed same instructions as suggested by MS.when i run our form it does add a icon to systray which is great but when i click on icon it gives an error...
  10. sqlpro

    update-sql

    hi friends i am trying update a table with the values from a cursor where it matches a condition.the code is update master set town=curtemp.town where master.streetname in (select name from curtemp) and empty(town) but its updating with wrong values! am i doing any wrong? Thanks for ur ideas...
  11. sqlpro

    calculating memo flds

    Hi friends we r in te processing migrating our vfp data to sql server. and in the process we need check memo fields and find out if it is necessary to make them as text datatype in sql server or keep them just as varchars. i need to start examining the memo fields in each table to determine...
  12. sqlpro

    GROUPING QUERY

    hI FRIENDS I HAVE DATA LIKE FOLLOWING Master Type 1111111111 Avail 1111111111 Meet 1111111111 Oper 1111111111 TD 1210 Avail 1210 Avail 1269 Avail 4532 GC 4532 JA 4532 Avail 4532 Oper I WANT FINAL OUTPUT LIKE BELOW Master Type...
  13. sqlpro

    _screen windowstate

    hi friends is there any way to know the _screen is minimized bcoz i need to add some when it is minimized. Thanks cheers
  14. sqlpro

    VFP8 to VFP6

    hi friends I have a program in VFP8 and i want use same program in VFP6 but i am getting errors while running it. i know that i can put breakpoint and findout possible conflicts. i am wondering is there any better to achieve it ? Thanks. cheers
  15. sqlpro

    sort data in grid based on logged in user

    FOLLOWING IS SAMPLE DATA i am showing in a grid Assid Staffname 516 rajani 518 Alana here staffname is logged in user name. is there any way i can show logged in user record as 1st row in the grid. in abv example if logged in user is Alana then 1st row should be Assid...
  16. sqlpro

    grid's setall

    hi friends whats the problem following command. Grid1.SetAll("ReadOnly",iif(curAss.ASS_COMP=1 OR ; !UPPER(ALLTRIM(THIS.sdummy3))==UPPER(ALLTRIM(gcstaffid)),.T.,.F.),"Column") it does not disable column as required. by the way what is my requirement is the column 5 in the grid bound to...
  17. sqlpro

    map logins

    Hi friends We have small application i.e Tracker(VFP8 and sql server) in our development which tracks our daily tasks and assignments. during the day we open many other applications which also expect a userid and pwd to login like Tracker. sometimes it becomes so tidious entering those login...
  18. sqlpro

    grid rows

    hi guys I have a grid that displays data based on some paramaters. How to disable some rows it displays bcoz grid has checkbox control which can b marked by user only under certain conditions. what happens is some rows in grid dont meet those conditions so i dont want user to update those...
  19. sqlpro

    tab order

    hi friends is there any easy way of setting tab order. i have 50 controls on a screen and i add new control atleast once week or delete according new requirements. it becomes so tidious setting tab order once add or delete controls. Thank you very much cheers
  20. sqlpro

    execute command using setall

    hi friends is it possible execute a method of all combo boxes on screen i mean something like .SetAll("value",'',"btextbox") i have control (jlist based on combo) which has a method refreshcontrol when i try like .SetAll("refreshcontrol",,"jlist") i get error like refreshcontrol is...

Part and Inventory Search

Back
Top