ObjectPAL Topic

How I can connect to a MS SQL database 2008 with ODBC? is possible through a ObjectPAL?

{Too Long}

Hi Does anyone know if it's possible to change the icon of the mouse cursor? I want to change it to an arrow when hovering over a table, instead of the 'line' cursor. Thanks for any help!

I'd like to be able to control Chart Series line properties in code.  Specifically, I am trying to control LineStyle. Chartobject.Series.Line.LineStyle = NoLine works, but it only controls the property of the first series.  I have tried Series1 and a variety of other names, but I haven't been able to find a syntax that works.  I know there is one, I have used it in the distant past, but I don't remember the syntax and I don't find it in the help. SS

Hi, New to this thread....just happy to see that I'm not the only one still using Paradox! I can't seem to get the sendkeys function in objectpal (pdx 11) to work with Vista.  Does anyone have a solution? Thanks. Todd

I am encountering an error when I try to post table data using a tcursor in ObjectPAL (Paradox 8.0).  System error reads: "An error was triggered in the 'postrecord' method on an object of tcursor type" --> "This record is not locked so the operation is invalid."  I'm not sure how the record would be unlocked. The main code is attached to a pushbutton event. At the top, I open a tcursor to a specific table (e.g., tc1.open(ATableName)).  I use some qlocates to search for and test certain dates and values.  Then I tc.close(). No problem. A little further down, I call a method that's also attached to the pushbutton object.  Inside the method, I open a differently-named tcursor to that same table (e.g., tc2.open(ATableName)).  I do some qlocates and later post some data to several different records in the table.    The data posts without a problem.  At the end of the method, I make sure to endedit() and close(). A...

#Formdata1  Var FD1_uiO    uiObject FD1_tC      tCursor #Formdata1  Arrive var a_logl       logical s_str         string n_lInt       longInt endVar   if (eventInfo.isPreFilter())  then      ;;//for each object (i.e. box, container, field)      if (active.class  = "Field")  then        n_lInt  =  FD1_tC.RecNo()        n_lInt.view ("Viewing RecNo...")      ;;  ALWAYS DISPLAYS the number one "1"                                              &nbs...

I am currently using pdox8 and woulld like to know the best way to ompact a table after deletes. I tried tblvar.compact(), this retruned an error. What is the best way to do it?

#Formdata1  Var   FD1_uiO    uiObject   FD1_tC      tCursor #Formdata1  Arrive var   a_logl       logical   s_str         string   n_lInt       longInt endVar   if (eventInfo.isPreFilter())  then      ;;//for each object (i.e. box, mro, container, field)      if (active.class  = "Field")  then          s_str  = self.TableName          a_logl = FD1_tC.open(FD1_uiO)          arriveFieldObject()      endIf  else      ;;//for Form only      s_str  = self.name      a_logl = FD1_uiO.attach(s_str)      s_st...

Can someone help me understand the mechanics of using OLE Auto. I am trying to understand how I find the methods for each application that I wish to communicate with. Ther are several enumeration methods I can use in Paradox that give me information about the available servers. I would like to be able to understand how i can manipulate Excel. Where do I find how to initiate the communication. After initiating where do I find documentation to open a file, go to a cell, etc. I have used OLE Auto only in a very simple way and would like to unsderstand it better.

In ObjectPAL, a developer can use the... ui.create() method to add uiObjects to a form with PageTool, BoxTool, ButtonTool, ChartTool, ElipseTool, GraphicTool, LineTool, OLETool, FieldTool, etc. Is there a similar feature available in C# .NET? 

method keyPhysical (var eventInfo KeyEvent) var    prev_key            keyEvent   s_str                   string endVar    s_str  = "keyPhysical " +,           " eventInfo: " + eventInfo.vChar(),    s_str.view ("Viewing...")                         ;; displays  "VK_INSERT"    prev_key.setChar(eventInfo.vChar())        s_str  = "keyPhysical " +,           " prev_key: " + prev_key.vChar(),    s_str.view ("Viewing...")                  &...

I am trying to streamline a work flow for our secretary and it occurred to me that she can sequentially copy multiple texts in another application to clipboard with cntrl-c. She can do this in sequence. Say family name, given name unit number. Can she then click on a button in Paradox to distribute these values to a Paradox table?? No problem for a single item, but what about the multiple values? Thanks, Paul. oops excuse the douple post!

I am trying to streamline a work flow for our secretary and it occurred to me that she can sequentially copy multiple texts in another application to clipboard with cntrl-c. She can do this in sequence. Say family name, given name unit number. Can she then click on a button in Paradox to distribute these values to a Paradox table?? No problem for a single item, but what about the multiple values? Thanks, Paul.

Can someone tell me how to bring up a list of who is currently in my application?  Iv'e done this before but cant for the life of me remember how now.

Howdy,So here's the setup:-data server (windows 2003):holds all of our database files, forms, reports,...-terminal server (windows 2000):used to be used for all staff, now used for  administration staff and has a copy of paradox 10.-terminal server (windows 2008):used for some admin staff and almost all sales  staff and has a copy of paradox 10.Users on the 2008 server can no longer paste pictures to a graphic field without the UAC making a big fuss. I can't find a way to mark the executable CDRCONV.EXE as an innocous process and our sys admin only knows how to add new users to the system, even simple printing problems are being farmed out. Does anybody know how to cure this ?Another small problem: how do I stop the 'Paradox for windows has stopped working' dialog box from coming up every time someone closes down Paradox.Thanks Eric

Hi, I would like to enumerate all network drives or should I say, valid paths to them. I am able to enumerate their 'names' from the registry but not the associated 'real' path. For example: I can obtain a reg key file name Dell laptop (Inspiron) but am unable to extract the actual path:  \\Inspiron\C dell laptop.  The browser nethood file name does respond to fs.findfirst. The actual path displays in the comments column when viewing My network places.  I did some registry searches for actual paths to see if I could reverse engineer but the only results found is MRU stuff. This is surprising. I've actually written a parsing proc to switch around the name...but it is klunky and unreliable at best. This needs to be accomplished in OPAL Paradox 9. Ideas welcome. Hope this makes sense. Thanks. Randy

I’m running into one problem after another with this assignment I’m doing. Harrr. This time it’s about the output file that I’m trying to create with a textStream. I believe I’ve found a partial solution to some of the problems I have if I can add text lines to the start of the text file. I’ve tried it, but no matter what I do, the original first line always get overwritten. I first tried a normal new file open(name,nw). then I tried to create a new file, close it, then open the file in append mode open(name,a). Nothing helps. Is it at all possible to add text to the front of a text stream?

Hi can anyone help  I am trying to insert a few extra lines into an existing text file.  the text file looks a little like this: 1   %%3000, 2   X161715Y35802T1T0, 3   X161715Y31502G01G42F10, 4   X177715Y31502G01, 5   X177715Y35802G01, 6   X177715Y35802T0, 7   X177715Y39202T0, 8   X177715Y44502G01G42, 9   X161715Y44502G01, 10 X161715Y39202G01, 11 X161715Y39202T0, 12 XYM50, 13 $T1D320S20F7R100N16Z0.220, 14 $ i need to insert new lines between line 12 and 13 this finished result should look like this 1   %%3000, 2   X161715Y35802T1T0, 3   X161715Y31502G01G42F10, 4   X177715Y31502G01, 5   X177715Y35802G01, 6   X177715Y35802T0, 7   X177715Y39202T0, 8   X177715Y44502G01G42, 9   X161715Y44502G01, 10 X161715Y39202G01, 11 X161715Y39202T0, 12 XYM50 X114300Y3000T55M31, X342900Y3000, X454200Y190500, X454200Y419100, X-213599Y4999M50M30, $T55D320S20F7R100N16Z0.220, $" 13 $T1D320S20F7R100N16Z0...

Hi, , My first post. I am trying to open a table in MS SQL 2008 that has a column defined as a ROWGUID datatype UniqueIdentifier and it fails. Is there a way to add this datatype mapping to BDE or get around it in ObjectPal? The ROWGUID is necessary to use FileStreaming for data in MS SQL 2008 so I cannot remove the column from the table.

The subject line says it all. Any ideas for enumerating files from an arbitrary folder and include subfolders as well? Actually, all I need is to enum a folder tree and write all the subfolder paths to a table. But either way...  It's easy enough to separate the files from the folders. I've tried a few things but have yet to come up with an air tight solution.   I've been writing opal for a long time but this one has my brain in a twist.  I'm using paradox 9. Thanks. Randy

Hi All,, , In one of my programs (created with the great Paradox 9 dev. edition) I give the user the possibility to fill a memo field with two or three A4-pages of text. When I want to print the text on a report (in a memo field) the last sentences (or lines) are not printed. The rest of the text is printed fine. Que Pasa ????, , Gr. Ron

Hello everyone,, My question revolves around the following scenario: A user opens Paradox app1, does some work, minimizes, then proceeds to open Paradox app2. Either the user will recieve "BDE busy" message immediately or they'll get to the first form, but if they try to move to another form, they recieve a "cannot open form error". I believe this is due to the Working Directory still being where Paradox app1 resides. How do I go about allowing a user the ability to have multiple Paradox applications running simultaneously? I recall something about a Session method. Is this the proper way to go, and if so could someone elaborate? Thanks., , B.

I am running Pdox11 on a Windows 7 machine.  Manually I can import an Excel spreadsheet (.xls) saved as a very early version of Exced using the import tool into a .db file and open it in Pdox.  I am trying now to automate the process using a script with the following code:  if not importSpreadsheet(":work:FileName.xls", ":work:FileName.db", "", "", True)  then,   errorShow(),    endIf But this gives the following error message:  "Unable to get table field discriptions"  and the process goes no further.  Using   dlgImportSpreadsheet ( fileName ) also does not work.  Any suggestions would be greatly appreciated.  Thanks.  Ian. ianespie@mweb.co.za,

Hello I use Paradox 9 + SP3 on Windows XP SP2 or 3 I had an old problem that i never found the solution hopping you can help me i use a customize paper size 8.5" * 5.5" to print on Epson dormatrix printer LQ300 but paradox take the paper always as 8.5" * 11 " and the printer do not stop at the end of my customize paper i tried since long time to find a solution for this bug of paradox but no hope please if you have any idea to resolve the problem i will be thinksfull I NEED TO MAKE STOP THE PAPER AT THE END OF MY CUSTOMIZE PAPER Thank Hicham TAWIL