Jump to content

Mikaymikz

Member
  • Posts

    11
  • Joined

  • Last visited

Everything posted by Mikaymikz

  1. Thank you for your advice MullinRJ and hippothamus! I appreciate it. One more question though, if you don't mind (or probably more to follow after this ). Is it possible to Write values to a database table without going through a record format? I am currently unsure how to use the following functions. 1. DBObjSQLSetWrite 2. DBObjSQLGetWrite I don't think I can use Function:DBSQLExecuteDSN for this, or can I? Thank you soooo much! Sincerely, Mikaymikz
  2. Hi all! Can someone please tell me whether it is possible to get values from a dialogue and input those directly to a Record Format without attaching it to an object? If yes, can you please give me a tip about what function to use? Thank you in advance! Sincerely, Mikaymikz
  3. I cannot seem to leave my Connection options checked. I go to Tools >> Database >> Record Format Connection >> Edit a Format Name >> Check the boxes for adding and deleting rows in database under "Connection Options" button
  4. Help! For testing purposes, I currently have multiple DSN's that can be connected to my Vectorscript document, through the "Manage Database" option. DSN Type: 1. MS Access Document 2. Filemaker Pro Document Problem encountered: I cannot use the DBDocAddConn function for my Filemaker DB, but my MS Access DB connects okay. Any thoughts or pointers on what setting I need to check? Thank you very much! Sincerely, Mikay
  5. Can someone please tell me how to use the function "DBSQLExecuteError" in Vectorscript? I'm not sure if I am doing it right, but below is my sample code which has given me two results, so far. SAMPLE SCRIPT PROCEDURE CheckDBError; VAR msg , state, internalDesc : DYNARRAY[]OF CHAR; code : LONGINT; error : BOOLEAN; BEGIN error := DBSQLExecuteError(msg, state, code, internalDesc); AlrtDialog (Concat('Error Output = ', code)); END; Run(CheckDBError); =========================================================== RESULT 1. -1317141234 2. 2883687 Thanks. Sincerely, Mikay
  6. Hello world! :grin: Has anybody encountered the type of error below when trying to connect Vectorworks with a Filemaker Pro file from a different PC host? *Points to Consider: 1. I installed 32 bit client driver but it does not reflect when I access ODBC so I cannot start the process to connect to database. 2. I installed 64 bit client driver but it gives me the error below, Message: "[FileMaker][FileMaker] xDBC client must be on the same computer as FileMaker Pro" Thank you in advance for the assistance! :blush: Sincerely, Mikay
  7. Thank you so much Sir Miguel! I will check it out.
  8. Hi guys! I'm basically new to our forum and utterly new to Vectorworks. So I have a gazillion questions in my mind, I'm just not sure how to ask them properly. Anyway, here goes... I am currently studying how I can transfer cell values from a VW Worksheet to an MS Access DB. I have already established a connection between my 'Test Database' and my Vectorworks document through ODBC. But, my problem is how to connect a worksheet to my database. Can anybody please share with me a simple code that also shows how I can integrate my SQL statement with ODBC to link my files? I would very much appreciate all your suggestions! Thank you very much! Sincerely, Mikay
×
×
  • Create New...