Recent content by reevda

Try it this: 1) create a datawindow and save it (dw_test) 2) datastore lds lds = create datastore lds.dataobject = "dw_test" lds.SetTransObject( SQLCA_2 ) lds.Retrieve() 3) don't forget to destroy it when finished destroy lds

In the menu try: Design -> Option -> "General" tab, deselect "retrieve on preview".

Hi Try this: long ll_rows, i integer li_del ll_rows = dw_3.RowCount() for i = 1 to ll_rows li_del = adw.GetItemString(i, "mark") if li_del = "y" then adw.DeleteRow(i) i-- ll_rows-- end if next

Try this run( "c:\program files\internet explorer\iexplore.exe http://www.yahoo.com")

Hi Kido, If you use SQL Server, try this: select c1, sum(isnull(case c4 when 'T' then c2 end,0) ) as C2_T, sum(isnull(case c4 when 'X' then c2 end,0) ) as C2_X, sum(isnull(case c4 when 'T' then c3 end,0) ) as C3_T, sum(isnull(case c4 when 'X' then c3 end,0) ) as C3_X from __test group by c1...

I use a grid dw, not a freeform (can't read format). But if i use a freeform, the type is "char(4099)".

Hi, i recetly had the same problem. I noticed that if the column > 255 on the DB, the datawindow retrieves only the first 255 char. The solution i found is to convert the column type to text. You must disable and enable the column in your datawindow again, and it should be ok.

Hi, try this: dw_1.AccepTtext // at the begining of then itemchange event.

Have you tried this: dw_header.getsqlselect( ) ?

I'm going to set the dddw to not editable. Thanks DR

Hi, I have a dddw field, and i would like that when the user types the first letters, this field gets automaticaly filled with a proposition (ex: user types "Eu", the field proposes "Europe" which is in the dddw list). PS: the field is allowed to editing. Can someone help? thanks DR

Hi everybody, Trying unsuccessfully to find the correct syntax to move a sheet in excel through OLE. (PB 8.02 with WXP pro.) Code which is ok: ---------------- xlapp.Application.ActiveWorkbook.Worksheets.Add xlapp.Application.ActiveWorkbook.Worksheets("sheet1").Name = "last" xlsub =...

No need to close the cursor if executed in pb. Automatic delete @ end of transaction.

Hi, did you check the Live scrolling option in the DW propriety ? Or try this line in a script dw_result.LiveScroll = true

Thanks forthe tip, it works. bye DR