Hi Darren, Yes tried that, it only exports the standard column headers, any additional headers you add don't export. I have had to do a workaround by exporting without column headers, and adding 3 additional lines at the top of the table and copying the column headers titles into these fields. i added these on the export button then remove them them once exported. Cheers ISOby ISO - WinDev Forum
Hi, Im trying to export a table to excel using the command: TableToExcel Ive tried all the 'options' taWithLayout etc The problem is my table has over headers which are not being shown in the export, anyone think of a way to include these in the exort? thanks ISOby ISO - WinDev Forum
Are you wanting to use RFT? Maybe this helps: //EDT_footer // this is an RFT field //EDT_body // this is an RFT field with image myItem is object OLE dynamic myOlApp is object OLE dynamic myOlApp= new object OLE "Outlook.Application" myItem = myOlApp>>CreateItem(0) myItem>>Subject = "Subject" myItem>>Recipients>>"someone@hotby ISO - WinDev Forum
i use the following, where EDT_body is an HTML field containing the image(s) bdy is string ="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang2057{\fonttbl{\f0\fswiss\fprq2\fcharset0 Segoe UI;}} {\*\generator Riched20 10.0.14393}\viewkind4\uc1 \pard\f0\fs17\par}"+ EDT_body MyMessage..HTML = bdy EmailSendMessage(nOutlookSessionID, MyMessage)by ISO - WinDev Forum
Hi, I have a looper which displays images, but i want to be able to position the image in the looper either left/middle/right i have tried setting various attributes for the image within the looper control like ImageMode = imgCentered but it just seems to ignore it and only shows the original display mode of the image. has anyone else had any success with this or can think of aby ISO - WinDev Forum
found dRotation any ideas on how to rotate a looper?by ISO - WinDev Forum
Hello, Is there a way to rotate a component specifically a Looper, failing this how about rotating an image? thanks ISOby ISO - WinDev Forum
Hi its definitely something to do with my setup i ran the same queries on the Clients Server and it was done in minutes similar times to Arie! My system has a much higher spec than the clients server, i did notice the cache of the indexes on my server was set to 30%, other than that cant see any difference. Art, i was just refreshing the datafile in the control center to see the number ofby ISO - WinDev Forum
Hi Darren Its C/S, Its also the same with Hdelete. I have to run the queries on the Clients Server, maybe its just a case of my local system setup, i ll see how it goes on theirs, thanks for your help and advice, i ll let you know how it goes. Thanks ISOby ISO - WinDev Forum
Hi Darren The file is indexed on saledate2 which is used in the WHERE part of the query. Would this slow it down?by ISO - WinDev Forum
Hi Paulo, Thanks for your reply, there are no links. The query has been running 6 hours Number of deleted records: 77,914by ISO - WinDev Forum
Hello, 1st post on the new forum, thanks Guenter for setting it up I have a simple delete query: DELETE FROM ORDER_TABLE WHERE ORDER_TABLE.saledate2 < {Paramsaledate2} the table has around 150k records which would be removed my the above, my problem is how long its taking to remove these records it been running for hours and only about 30K records have gone so far, this cby ISO - WinDev Forum