Hi Craig, its Jacob. Yeah I was coming to that conclusion. It was just so handy for having users reorder short lists that I was hoping someone had done it. Thanks.
Jay
This is more of a .net question but I am hoping someone who does vfp and .net will have an answer for this. I am looking for a .net control (commercial 3rd party is fine) that has the same functionality as a VFP listbox with the mover bars turned on. We are doing a conversion and we use the...
IE7 Beta 3
Does anyone know how to make IE7 report itself to a website as IE6?
It seems to report as Mozilla 4 which one website I have to use is reading as IE4 and then refusing to work saying it need to be IE6.
I hate to have to go back to IE6 for this one stupid site. Also they are a...
You would be better off creating a Sql Server view on one of the server that accesses both tabes. The one on the other server using a linked server connection. Then create a VFP view on the SQL Server view.
I posted this in the Integrate forum no responses thought I would give it one more try.
I have been banging my head against the wall on this one.
I am trying to get Crystal 11 to work with a Windows Logon (Integrated Security) and a sqloledb connection.
The preview activex control is...
I this case I really need the VFP field to be a general since we use it to launch ole embedded documents. Is there a way to fool it so the update works and I end up with a general field in the cursor that VFP gets back?
I am experimenting with using a cursor adapter to update a SQL 2000 image field. I used the builder to create an adapter in a test form and basically took the default values. Its attaching using ADO. The update back to the server works fine as long as the image/general field is null. However...
If you are running this fr4om query analyser, make sure YOU are not in the DB you are trying to rename. You should not have 'accounting' in the dropdown box at the top that selects the db nane. I can't tell you how many times I have done this myself.
Terminal Server. If you set it in admin mode you get 2 free connections. Then just use RDC Remote Desktop from your XP or 2000 box.
I would also recommend your office have a VPN connection set up so you are accessing through that, rather than having your SQL Server hanging out naked on the...
I have been banging my head against the wall on this one.
I am trying to get Crystal 11 to work with a Windows Logon (Integrated Security) and a sqloledb connection.
The preview activex control is exhibiting some weird behavior and does not seem to work like the design activex control.
The...
assuming value is numeric
select id,
sum(case when type = 'type1' then value else 0) as type1,
sum(case when type = 'type2' then value else 0) as type2
group by id
order by id
if it is not numeric replace sum with max, matter in this zero with the empty value equivelant for that data type.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.