A few Questions on VFP 5.0a 
Author Message
 A few Questions on VFP 5.0a

I have a couple of questions and a problem regarding Visual FoxPro 5.0a.
First I have been informed by our manufacturing software provider that
their ODBC driver will not work with any ODBC version 3 compatible
software until the release of version 6.1 of their software which is now
in beta. Since all of our VFP 5.0 project work with the current ODBC
driver I'm assuming that VFP 5 is only ODBC 2 compliant. Does anyone know
what future release of VFP will be version 3 compliant so we can avoid it
until we upgrade our manufacturing software? My other question is does
anyone know of a way to have a grid only display full rows. I currently
have a grid on a form and if the user resizes the rows so that the last
row can only show half the row I would rather not have it show the row at
all. Can this be done? Now my problem. I have a spinner on this same grid
and the initial value is 0. If a user types a 1 into this grid and tabs
off of it or mouse clicks on another field the 1 becomes a 10. I have
tried setting the Highlight property to .T. and the SelectOnEntry property
to .T., but the effect remains the same. Is there anyway to set it so that
when the user enters the spinner and enters a 1 and then tabs off that the
value is set to 1 rather than 10? Oh, also, is 5.0a the latest version of

chance to follow this newsgroup too regularly.

--
I'm just live a devil, you're just like a witch
You only like me because I scratch your itch
I'm too much a bastard, you just like to {*filter*}
I'm just like a devil, you're my witch
- Jackyl.



Mon, 22 May 2000 03:00:00 GMT  
 A few Questions on VFP 5.0a


Quote:

> I have been informed by our manufacturing software provider that
> their ODBC driver will not work with any ODBC version 3 compatible
> software until the release of version 6.1 of their software which is
> now in beta. Since all of our VFP 5.0 project work with the current
> ODBC driver I'm assuming that VFP 5 is only ODBC 2 compliant.

Right. If you're going to use SQL Pass-Through, sending sql statements
to the backend through SQLEXCUTE(), you' can send hatever SQL the
baclends. ODBC can handle, regardless of VFP's ability to handle a
similar SQL itself.

Quote:
> My other question is does
> anyone know of a way to have a grid only display full rows. I
> currently have a grid on a form and if the user resizes the rows so
> that the last row can only show half the row I would rather not have
> it show the row at all. Can this be done?

You can save the Grid.RowHeight to a form property and check if it's
unchanged in AfterRowColChange. If it'sv been changed, you can calculate
if the new value is whole  multiple of available space and adjust it.
You can also turn off row resizing by setting Grid.AllowRowSizing false.
 Adjustment to the column widths can be tracked automatically in the
column.resize event, but there's no such event for row resizing.

About your spinner problem. for the range 99 tp 0, set the
spinner.Increment to 1. or 1.00, the spinner.InputMask to '99' and the
KeyBoardHighValue to 99, KeyBoardLowValue to 0, and the SpinneHighValue
and SpinnerLowValue to 99 and 0.

-Anders

!^NavFont02F051A0007MIF2HLbBDF6

--

12/05/97 17:03
---------
Using: OUI 1.8 Beta 7 from http://www.peaktopeak.com



Tue, 23 May 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VFP - A few questions

2. A few questions about using an SQL server with VFP

3. A few VFP questions.

4. Few questions about VFP 6.0

5. Follow up question to previous thread on VFP 5.0a query questions

6. Follow up question to previous thread on VFP 5.0a query questions

7. Question about VFP 5.0 and VFP 5.0a

8. To 5.0a or not to 5.0a, that's the question

9. A few string manipulation questions for Foxpro on Macintosh

10. A few top-level FoxPro questions...

11. A Few questions about Programming VFP6

12. A few Fox Programming Questions

 

 
Powered by phpBB® Forum Software