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 bkrike 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: dickylam
  • Content: Threads
  • Order by date
  1. dickylam

    Duplicate server names

    I really do not understand, I have a win2003 server running SQL 2000 server. Everything is fine. I have a client using win2000 professional and attempt to use odbc to create a link, but i found 2 duplicate server name and I do not know which name i can choose, as a result, the program cannot...
  2. dickylam

    image file need to copy or not

    I have a question, If I have a image, which I make it through a class. Now, I create a simple form (modal), and add such class into the form, since the image contain image file. Then, I compile and build execute on it, and I obtain an testform.exe (for example) and now, I simple copy this...
  3. dickylam

    Ask a login name and password while no password is set

    I have a strange question I have a server, running Win2K server, using active-x directory user and domain to set all users name and password Also, I have 4 sets of workstation running Windows Xp Home By the way, everything is working fine. Except If I double click the "My network...
  4. dickylam

    Strange! Strange ! Strange!

    I am using MS-SQL Server 2000 for database and use ADO as well as SQLVIEW to open, edit and save the tables. For details, I put my code here:- main_ado = createobject('adodb.connection') main_ado.open('maindb','sa') The above lines declare an object and open maindb database which has been...
  5. dickylam

    Using Formula and Using Crystal Syntax

    I am using Crystal Report Developer 8.5 to develop report with database of SQL server. I use Visual Foxpro as front-end. While I am designing report in cr85. I face a problem. This problem is:- I have the column Date,reference,description,debit,credit In the table, the fields are:- table...
  6. dickylam

    dbsetprop fetchsize not running even set to -1

    I have a table in sql database's table which contains around 31,000 rows (records). I use SQL passthrough method to access the table and use SQLVIEW to load all records. create sql view temp_view remote connection zodbcname as "select * from ztable" select 0 use temp_view...
  7. dickylam

    About SWF

    I have seen most of the flash has the extension of "*.SWF" when browing internet pages. I have few questions:- 1. Is it the only SWF extension, any other extension have similar result (except animated GIF) ? 2. These SWF can be revering engineering into fla ? 3. Will the swf format...
  8. dickylam

    How to know the last event or action done by user

    Although I have made a error capture program by using on error with para1,para2,para3,para4,para5 But, error will come after certain event or action trigger by user. Therefore, how to know which event or action by user so that I can debug easily. Thanks.,
  9. dickylam

    How to install MSDE

    I am using ADO to access database made in MSDE which is almost same in SQL 7.0. I can use enterprise manager to open attach database. However, as I am new to SQL server, if I complete the application, how to copy the database together with my application ? Is is only copy database.mdf and...
  10. dickylam

    Help of listbox with number display

    I am facing a trouble. I have a remote view table wants to show in listbox. For example, 3 fields, the first one is char type, the second and last is numeric type. Let these 3 fields be fld1,fld2,fld3 respectively. If specify the columncounts = 3 and rowsourcetype = 6, the rowsource =...
  11. dickylam

    How to get the total record in SQL table

    I am using SQL Server database I am using also ADO as basic connection, update...etc actions however, in ADO propertites, a recordcount is used to show the total number of records in that table, but this is long variable type, in VFP, how to create such type of variable and hold this result...
  12. dickylam

    Help with fetch size

    I am using SQL database with a table of increasing records. When I create a sql view with remote connection, I set the dbsetprop of fetch size to -1 (unlimited), I then can see all records in the table However, if the table is keeping growth, let say total 25,000 records, I still cannot see...
  13. dickylam

    Record Order and Sequence

    I have a question, if I select and open a table under a database with any order specified. How and what happen if I perform a test loop to insert 50 records, for example in the sequence. I found that the records are locating some at the top, some at the middle and some at the end, it seems...
  14. dickylam

    Search in Listbox

    I create a listbox which have rowpropertytype = 6 (fields) and rowproperty = (field1,field2) in a form After selected by the user, the whole data in the form is being saved. However, when the user call back the record saved previously in the form, the value is restored in listbox but ... WHY...
  15. dickylam

    Very strange form object reference

    I am facing very strange in VFP 6.0 I have a form with a name reference with it, like do form newform name newref before this form done, a small program is running and set newref to be public, like public newref however, when I try to use such reference to control the object, I will face...
  16. dickylam

    cannot find any shared folders

    I am really doubt. Please help. One computer, acting as win 2000 server , install active directory under windows explorer, I have made share a folder, share name called test, for example. Under the active directory, under the user in the domain name, (I have one domain only), I create a...
  17. dickylam

    Right click even in grid disappear

    Hello, I am feeling strange why the rightclick event function disappear after the grid's recordsource is triggered. Triggered means I have 2 forms, one form only show the grid and another form add/edit records, after closing the second form, I put a grid.refresh call to first form. Although...
  18. dickylam

    Ado works

    I am getting trouble in using ado, even though I read the section in MSDN, but no example for VFP, if read the jump start for VFP, only little help available... For example, I want to use the find method available ADO, but I always get OLE IDispatch.... which is telling me VFP do not...
  19. dickylam

    Create sql view remote...

    Anybody knows that if I issue a command as below:- Create sql view testview remote connection as testdb as select * from testtable The above action will create a cursor named testview and take data from the table of testtable. However, where is testview.db?, it should save in somewhere of...
  20. dickylam

    Everything about ADO

    Anybody can help me. I use VFP as front -end and user interface. I use SQL 2000 as datbase. I created adodb.connection and adodb.recordset Let say, xobj = createobject("adodb.connectio") zobj = createobject("adodb.recordset") However, I do not the syntax how to write open...

Part and Inventory Search

Back
Top