Re: [NF] Problem with MySQL COUNT syntax

Change my VFP code to convert afterwards. In my case, I stored the count in a memvar to drive a loop , so I just converted it to integer via VAL(the_count) At 06:11 PM 2007-05-01 -0400, you wrote: Larry Bradley wrote: Michael, I've been bit by the mySQL count being character. It happens

Re: [NF] Problem with MySQL COUNT syntax

Michael, I've been bit by the mySQL count being character. It happens with a simple select count(*) from table. CAST, etc doesn't fix it. I don't know if it is mySQL or the ODBC driver. Larry At 08:28 AM 2007-05-01 -0400, you wrote: Dave Crozier wrote: Michael, DOH! Just a matter of

Re: Dual-core issue - resolved

be the proof. Thoughts, anyone? I have no idea on how to solve this one. Many thanks Larry Bradley Orleans (Ottawa), Ontario, CANADA [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: [NF] -- Stored Procedure Organization

I just put my stored procs in the database as the tables they are messing with. But I only have a dozen or so. I can't think of why I might want to put them elsewhere. Larry Bradley Orleans (Ottawa), Ontario, CANADA --- StripMime Report -- processed MIME parts --- multipart/alternative

Re: Product license codes in your vertical apps

Michael: The answer, as always, is it depends. How much protection do you really need? Are your potential customers really going to try to do you in, given that if they do steal it, what will they do for training, support, etc? I suspect most crack sites will ignore a vertical market app that

Re: [NF] MySQL bit field default value

Mike, I'm using the mySQL Query Browser (on Windows 2K), and I used BIT(1) fields all the time. The default value field in this tool accepts 0 or 1 - not b'0' or b'1'. Try this with your tool. At 08:55 PM 2007-03-29 -0400, you wrote: I'm setting up a field in a MySQL5 table and trying to use

Re: [NF] MySQL bit field default value

2007-03-30 -0400, you wrote: Do you find that you prefer the bit field over tinyint(1), Larry? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! Larry Bradley Orleans (Ottawa

Re: Another life after VFP thread?

Generic reply, not directed ant anyone in particular: If you can write apps in VFP, you can write apps in anything. I've been a programmer since 1964. I've programmed in everything: IBM mainframe assembler, Cobol, PL/1, Fortran, a gaggle of PC languages, as well as programming for imbedded

Re: Bug in VFP SQLColumns() and MySQL 5 with TEXT fields?

mySQL 5.0.24a, ODBC 3.51.12, VFP9 SP1 A mySQL table defined thus: CREATE TABLE test ( Atext text NOT NULL, Avarchar varchar(45) NOT NULL, avarbin varbinary(45) NOT NULL ); and VFP SQLCOUMNS gives: atext Memo avarchar char(45) avarbin char(45) NOTE that it does NOT translate the

Buffer overrun error

the errors that I get on the dual-core machine) so it is a bugger to track down. Thoughts? Larry Bradley Orleans (Ottawa), Ontario, CANADA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free

Re: VFP 6 Grid: Hide empty dates?

Sure. If the grid column is to be read-only, you can use an expression as the control source: iif(empty(my_date),'',my_date) At 06:35 AM 2/20/2007 -0500, you wrote: Hello, I have a grid in VFP 6 and the controlsource for one of the columns is a date field. If the date is empty it shows /

Re: VFP 6 Grid: Hide empty dates?

is well. Now for future because I know it'll come up...how would you suppress the slashes if the table column is not read-only? Regards, Andrew Baker Larry Bradley Orleans (Ottawa), Ontario, CANADA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body

RE: Dual-core issue?

). Obviously they've got it to work - most of the time - but I really wonder if it can be made to work reliably ALL of the time. Bill Larry Bradley Orleans (Ottawa), Ontario, CANADA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text

Dual-core issue?

to disable part of a dual-core machine via the BIOS? (This is an ACER machine, which I think uses an AMD chip set). That would be the proof. Thoughts, anyone? I have no idea on how to solve this one. Many thanks Larry Bradley Orleans (Ottawa), Ontario, CANADA

RE: Dual-core issue?

if it can be made to work reliably ALL of the time. Bill Larry Bradley Orleans (Ottawa), Ontario, CANADA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox

RE: Dual-core issue?

to monitor the task manager? That'll show you if the process is running as 1 thread or two. I'm thinking that the SQL and VFP may run async at times. Larry Bradley Orleans (Ottawa), Ontario, CANADA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body