VO2.6 Win 7 and dbServer Editor

I've been using 2.6 happily for a while now on a Win 7 64 bit system - all worked OK. Yesterday I could no longer use the dbServer Editor - greayed out - the only options I could select were Source Code Editor, Menu and Report editors for either an existing or a new entity. Has anyone experienced this and, if so, did oyu overcome it? A complete removal (uninstall fails because it can't find a required product!!! even though the system and system drive have VO 1.0, 2.0 and 2.5 all installed on it), repair and even a re-install in different directories can't get other editors going. 'Subsystem

Page counter in ReportPro36

Hi all, I have wish of my client who want to print more invoices, not separately, wherefore I can't use function PgNo() because PgNo() gets page number of complet report. For this reason I have created special variable for that (for example nRzuPage) and set section, group and this variable in reportpro like that: Section: Server table: Rzu.dbf (index Rzu.cdx, key expression: Kbr) Child table: Rzus.dbf (index Rzus.cdx, key expression: Kbr) Relation: Kbr Group: Name: Rzu.Kbr Expression: Rzu.Kbr Reset At:

How to implement Excel Sort command in VO?

I want be able to sort a range of data in an Excel workssheet I created from VO. Excel generated method is: _DLL METHOD Sort( Key1, Order1, Key2, Type, Order2, Key3, Order3, Header, OrderCustom, MatchCase, Orientation, SortMethod, DataOption1, DataOption2, DataOption3 ) CLASS ExcelRange:ExcelOle28.ExcelRange:Sort Macro which can do the job is: Range("A3:Q254").Select Selection.Sort Key1:=Range("A4"), Order1:=xlAscending,Header:=xlGuess,_ OrderCustom:=1, MatchCase:=FALSE, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal which I translated as: oIEx:oRange:= oIE

PSZ or PTR

Can someone clarify the following please... A function declaration like : _DLL FUNC AdsDDFindNextObject( hObject AS DWORD, hFindHandle AS DWORD, pucObjectName AS PSZ, pusObjectNameLen REF WORD ) AS DWORD PASCAL:ACE32.AdsDDFindNextObject The parameter pucObjectName is set up with pszObjectName:=MemAlloc(500) (or whatever value) Is there any difference or preference between declaring LOCAL pszObjectName AS PSZ and testing for !=NULL_PSZ after the MemAlloc call and LOCAL pszObjectName AS PTR and testing for !=NULL_PTR after the MemAlloc call TIA Nick

Word-compatible Text Editor

Following on from another thread I started on embedding Word, I want to pursue another line of enquiry... Which 3rd party (OCX or .NET) text editors are people using? I'm interested to know which are most compatible with Word, and most reliable (and with good support, upgrades, etc.). The one we've used most so far is TX Control, but I'd like to know if anyone has other suggestions. TIA Nick

freezing/locking a Browser column with EnableVerticalSplit

Hi, I want to freeze the first (leftmost) column in an databrowser (NOT a bBrowser!) Yes, I read these posts, but they didn't help: 2002: http://groups.google.com/group/comp.lang.clipper.visual-objects/browse_thread/thread/3a6e8ae9e66763d6/0adee3f9d86bfcd4 1999: http://groups.google.com/group/comp.lang.clipper.visual-objects/browse_thread/thread/682020803651fc91/c8df7fe095e5a39b What I have to do is: after splitting the databrowser with oBrowser:EnableVerticalSplit(TRUE, GBSSBLEFT) - move the split 1 column right - scroll in the right half one column to the right, so that the f

Setfilter and date

Hi, I Have 2 posts in a database with the field "NYKALDAT" (date) containing Post 1 = 2010-05-17 Post 2 = 2010-04-08 // Visual Objects (Version 2.8. Build 2.2828), Version 2.8 SP2 Now I try to filter the database like this: ? DTOC(Today()) // Gives "2010-04-28" ? cFilter := "NYKALDAT" + " < " + DTOC(Today()) // Gives "NYKALDAT < 2010-04-28" uCB := &("{||" + cFilter + "}") // Codeblock ? SELF:oSFSub_Form1:Server:SetFilter(uCB ,cFilter) // Gives .T. SELF:oSFSub_Form1:Server:GoTop() DO WHILE !SELF:oSFSub_Form1:Server:EOF ? SELF:oSFSub_Form1:Server:Recno // N

Data Encryption and Non-English language issues

Hi, Since I know many people here on this NG use languages other than English, what is your take on the following? I have a client with the Japanese language installed on Windows 7 computer, however Windows XP computers with same language installed cannot read the decrypted data. I checked the regional settings but could not see anything I am not sure why this occurring as I always tested my program under Windows with the English Language installed as default. What settings in VO guarantee that help with issue? The only function that use in my app start-up is: SetAnsi(TR

Sending Message

Hi guys, One of my clients would like to send message through my app to the users. Anybody known if it is possible in VO and can give me an sample? Thanks. Jairo

memo fields problem...

Hi, VO 2.6 DBFCDX/FTP i have a problem with one table and their memofields... the table contains NOTIZEN, VERLAUF, ARBEIT as Memofield for example.. on one record i save a text in the field "VERLAUF".. on some other records now the same data contains exactly the same text in the field "NOTIZEN" or "ARBEIT" ... no linked server with datawindow or something like that.. CC_OPTIMISTIC is off. anyone an idea ? thanks, Mario

Display image from Resource

Hi all, I have added an image in a DLL using the following code: resource bmp_NoImage Bitmap C:\VOProjects\Membership\images\noimage.bmp define bmp_NoImage := 5000 I want to use this image in a FabPaintLibCtrl object using the following code, but the image fails to show up. oFabImg := FabPaintLib{} lSuccess := oFabImg:CreateFromResourceName(_GetInst(), "bmp_NoImage") //lSuccess := oFabImg:CreateFromResourceID( _GetInst(), bmp_NoImage ) The result of creating from Resource, by ID or Name, fails. If I create it from an external file the image is displayed correctly. Does a

MySQL in bBrowser

Hi, I have a problem in using MySQL in bBrowse 1.4 (Limited) with VO2.7B (Build 2740). I use ODBC driver 3.51. The browser takes a long time to load and also cannot focus in the browser to move up and down by pressing the up down arrow keys in the keyboard. The coding is as follows : oConn := SQLConnection{"MySQL-Server","root","1234"} oSelect := SQLSelect{ "SELECT * FROM SQL_TABLE", oConn } SELF:oDCbBrowser:Use( oSelect, , { } ) oColumn := bDataColumn{SELF:oDCbBrowser, SELF:oDCbBrowser:Server, ; {|oServer| oServer:Field1 }, #Expression, SELF} oColumn:Caption := "FIELD-1

WinForms to XAML UI Converter

This is probably more for the C#, VB and Vulcan group, but I thought this looked interesting: http://blogs.windowsclient.net/rob_relyea/archive/2010/04/16/winforms-to-xaml-ui-converter.aspx -- Ginny Caughey www.wasteworks.com

Placing markers on a map

Hi All, My question is simple; In a dbf there are some coordinates saved (lat. with long.). When the user hits the "map" button a browser (in my case IE) window should open, Google or Bing maps (or any other) should appear and some markers should be placed on the map. Opening Google or Bing maps is not the problem (something like ShellExecute(NULL, String2Psz('open'), 'http://maps.google.com/?ie=UTF8&ll=50.963069,5.793389&spn=0.002618,0.006947&t=h&z=18', String2Psz(''), NULL, SW_SHOWNORMAL)), but placing one or more markers. Maybe making somekind of script file on the fly

Error in MySQL

Hi, I am using VO2.7B and MySQL 5.1. I have some problem in using MySQL and hope that someone can help me about it. I downloaded the ODBC drive of MySQL 5.1 in www.MySQL.com and the configuration and installation works fine. I wrote coding as follows: LOCAL oConn AS SQLConnection LOCAL oSelect AS SQLSelect oConn := SQLConnection{ "MySQL", "root", "password" } oSelect := SQLSelect{ "SELECT * FROM SQL_TABLE", oConn } oSelect:GoTop() Igot an error at the GoTop line Error Code:4[numeric overflow] Subsystem BASE Function => WORD Argument:65536 Do not understand what

Qout does not show any terminal window

Hi, I can not display any terminal lite windows neither with qout non ? operator. Teminal Lite is included in the application, of course. Can you hel me? Thanks in advance. Massimo

Advice on multi-threading

In adapting our application to use replication and ADS, we have a process fired off periodically by a timer, which checks to see that all the remote connections and replication queues are functioning correctly. Ideally I'd like this to run as a separate thread, so that it doesn't interrupt the normal work in the app - some clients could have 15 or 20 remote systems and periodically the system will be accessing web- services to check on the status of all of them, so it could potentially be taking 1 or 2 minutes to complete. However it also constantly updates a status window on the ma

Eval/ForEach

Hi to all, How can I do to process all the records of a field using Eval or ForEach. I tried the two ways below, but both return error. Can you help me? Thanks!!! Jairo. Ex1 (ForEach): =========== LOCAL oAdoFields AS AdoFields LOCAL bBlock AS CodeBlock bBlock := {| oObj | Qout(oObj:value),TRUE} oAdoFields := oRs:Fields:[Item, name "] oAdoFields:Foreach(bBlock) Ex2 (Eval) ======== LOCAL oField AdoField oField := oRS:Fields:[Item, name "] eVal(oField, value ")

Importing and Exporting to Excel

Hi all, Until now, i have a mechanism to export a Sql table to Excel, but now i need import some lines from excel file to a Sql table. Any idea, please? TIA Paulo Oliveira

ReportProInit()

Hello, does anybody have the sourcecode of the ReportProInit() and ReportProUninit() functions? If yes, could you send it to my e-mail address? Unfortunatley the ReportPro-Manual does not explain exactly what's done inside these functions. Stefan

CEmail with charset = "UTF-8"

Hi, Is there a way to substitute in the CEmail class default charset = "iso-8859-1" by charset = "UTF-8". I'm using VO 2.8 SP3 (2837). Thanks, Ivan.

SO Service Client V1.3.3

Hi Folks. Here is my Easter gift to you all. It is basically an example of how VO can use COM to exploit what is very easy in C# and very hard in VO natively. You might even find a production use for it. It is all about VO generating emails, tasks, appointments, report services report viewers, direct print reports, bulk emails, error handlers and more. ftp://www.softwareobjectives.com.au/anonymous/so.service.client.zip For newcomers, see the notes way down below... New things for March: bulk email facility. For April: Setting and managing user passwords. Your email dia

Notebook for VO and vulcan.net

Hi all, I am looking forward to buy a notebook to work with VO and Vulcan out of the current PC. Are there experiences on your side ? Recommendations? At this moment I am thinking about a regular notebook with Win7 with an i5 or i7 CPU and 4 upto 8 GB RAM. Regular disk and grafic board should do the trick. What do you think about it? Feedback welcome. Thanks Niko

DBG not rewritten

Has anyone experienced the following problem: My DBG's are no longer recreated (any directory or application). As a result I don't see any change in my program after changing code. It happened suddenly without any (known) change in anything. My workaround is for the moment to delete the dbg from a DOS box everytime before a restart and that works without a problem. I've even rebuilt my complete repo by creating a new one and importing all programs, but that did not make any change. Dick van Kooten

Exchange

I have to load appointments in Exchange, where can I find examples also Vulcan or VO? Thanks Danilo