RE: MI MB: VB6 DLL Access from MB

2000-09-12 Thread PEM
Hi, Creating DLL and using them from MB is a big wish from many MB developers. Unfortunately, as Richard writes, VB created COM DLLs that can't be used from MB. But there is a tool made by Desaware that might do the trick anyway. The tools is called SpyWorks and it creates a alias DLL that

Re: MI Crystal Report

2000-09-08 Thread PEM
Hi, Sure it's possible to run a Crystal Report from within MapBasic. Here is the syntax: '* Open Report reportfilespec reportfilespec is a full path and filename for an existing report file. '* But now that we are discussing

MI Papersize definitions...

2000-08-04 Thread PEM
Hi, Is there anyone out there who has a complete list for the Papersize definitions for use in MapBasic 6.0. I know MapBasic comes with a Papersize.def, but the papersize definitions for A1 and A0 are missing as far as I can see. As far as I have figured out the values for A0 and A1 can

Re: MI SQL Select full jolin

2000-08-03 Thread PEM
Hi John, I haven't excactly tried it myself, but this ought to do the the job: 1. This SQL query requires that both of your tables has a Integer column. Lets call it OUTJOIN All the values in these two column should be the same, for instance 1. 2. Your SQL syntax would then be (I guess you

Re: MI MB Select using string variable

2000-07-26 Thread PEM
Hi Bill, Try this syntax instead: I take it that Population and MyTable is the real names for the table and the column and not variables/constants containing the real names. *** * Dim MySQL as String '1. If

Re: MI Run command and object variable - more details

2000-07-21 Thread PEM
Hi Serge, The problem is that the object variables are converted into text in your Run Command Statement. And when you convert an object variable to text, you get the type of object the variable contains/is pointing at. This also explains the error you are getting : "Variable og field Region

MI Problem with printing on HP8000

2000-07-21 Thread PEM
Hi There, I was wondering if there is anyone out there who has the same problem with the HP8000 printer when printing from MapInfo. Appearently this printer works most of the time. But in certain cases it just reports "Out of memory..." As far as I have figured out so far there seems to be

Re: MI Re: I lost my .TAB ... ARGH!!!

2000-06-16 Thread PEM
Hi, It's an even smaller problem than describes by Uffe. In MapInfo: File Open Table... Select FiletypesDBF In the Filename enter *.dat og hit Enter Go to the directory where your *.dat file without the Tab file is found. Select the *.dat file and voila... MapInfo automatically created the

Re: MI Tables

2000-04-18 Thread PEM
Hi Tony and others, I've created such a function to test whether a table is open or not and it goes like this: '-- 'Is table szTab open ? function '-- Function

Re: MI MapBasic PointInPolygon predicate function

2000-04-07 Thread PEM
Hi David, Concerning the problem with checking whether a point is within a region: You can use the geographical operators without SQL. That is you might ask if one object is within/intersects/contains another: ***

MI Re: Rotate Layout Window

2000-04-03 Thread PEM
Hi Sheila, Maybe I have misunderstood your problem, but why don't you just use A4 Portrait layout with 2 pages ? In this way you don't need to rotate the things on your layout. The two A4 pages will be on top on each other, if you just tilt your head a bit to the left ; ) I hope this helps!

Re: MI Determining if a table is open in MB

2000-03-06 Thread PEM
Hi Tim, The easiest way to determine whether or not a table is open, is as you mention your self to use the TableInfo() function, which will give an error if the table isn't open. And because this question might be asked over and over again, I would say that the best thing to do is to put

MI Using Crystal Peport from MapBasic

2000-02-17 Thread PEM
Hi, I was wondering if there is anybody out there who has had good result with calling the Crystal Report API functions from within MapBasic. I'm strugling quite a bit with these function and most of my work is doing OK, the only problem I'm still having is that I can't seem to be able of

Re: MI Calculating Volumes

1999-12-27 Thread PEM
Hi Nick, The calculation of volumens can be done in VM ! Do the following: 1. Create the grid with all your height data 2. Create another grid that covers the same area as the previos. This grid's values should be Z-value where you want the surface to be. Groundlevel or watersurface... 3.

Re: MI Create Text in a Layout

1999-12-23 Thread PEM
Hi Scott, If you are using MapBasic 4.5 or a later version there is a new function, that does the trick. Syntax: CreateText( window_id , x , y , text , angle , anchor , offset ) This function creates text from a centerpoint and you can then set different values to control the placement of

Re: MI Using the data in a String Variable

1999-12-17 Thread PEM
Hi Scott, The command for solving your problem is : Run Command LastView I hope this helps you! Best regards, Peter Peter Moller [EMAIL PROTECTED] Kampsax Geoplan, Denmark ** Scott Wrote: I have a string variable, (LastView), which contains the MB code to

Re: MI problem with clone view command

1999-12-08 Thread PEM
Hi, The Clon View work by creating a command string containing all information about the map, e.g. zooms, labels, etc. But this string that should contain all these information isn't allways large enough. The string is limited to 32K characters, well this the was the case a year ago and they

MI wacked out line length calculations

1999-11-17 Thread PEM
Hi Ben, I guess you problem here might be the fact that some ( or rather a lot ) of your records have been selected more than once, and therefore the entire length of all the lines will double, triple or more. Try the following: Select LineName, sphericalobjectlen(t_name.obj, "mi") From

Re: MI MB: can one control be made dependent on the output of another control in db

1999-08-12 Thread PEM
Hi Rajeev, Listboxes do have a Calling clause that activates a handler, when a change is mad to the Here is the syntax for this control. Control { ListBox | MultiListBox } [ Position x , y ] [ Width w ] [ Height h ] [ ID control_ID ] [ Calling