Iron Speed Technical Forums

File Upload

theath262 — Fri, 20 Nov 2009 19:33:48 GMT

I would like to alter the file upload control to send the uploaded file to an email and NOT save it on the server. Can anyone point me in the right direction?

Thanks in advance,
Travis

Forum: Using Iron Speed Designer V5.X

pdf reports and totals

kenehresman — Thur, 19 Nov 2009 22:36:50 GMT

Ok, so I selected totals and my page shows that just fine, but when I export to PDF the totals are not there...

how do I get the page and overall totals on the PDF report?

Forum: Using Iron Speed Designer V5.X

WHERE clauses that can't be done in the Query Editor

RichardRay — Thur, 19 Nov 2009 21:43:55 GMT

I need to filter the rows that will be displayed a page with a WHERE clause that I can't seem to create with the Query Editor

Code:

SELECT *
FROM  . 
WHERE CONVERT(CHAR(10), . . ,110) = CONVERT(CHAR(10),GETDATE(),110)

Where can I get at the WHERE clause specification to do that? Or, do I just edit the appropriate 'xxxxGetList' sp to add the filter there? Or am I back in view land?

Forum: Using Iron Speed Designer V6.X

Migration to v6.2.1 wants to overwrite existing table

troim — Thur, 19 Nov 2009 21:13:09 GMT

I am attempting to migrate a 5x app into v6.2.1.
When I try to change the database sql server name, it pops the application wizard, lets me sign in and once i pick the table, and click next errors with the message that the sqlservername.tablename is already in use and wants to remove it. I have data in the table and want to change the table reference but do NOT want to remove the data and I am not changing the structure of the table.

is there an option to not over ride the table somewhere?

Forum: Using Iron Speed Designer V6.X

5.01 Return CInt(AppDebugLogTable.Instance.GetRecordListCount(where.GetFilter(), Nothing)) generates exception

troim — Thur, 19 Nov 2009 15:55:32 GMT

I have an application that has been deployed for a year. yesterday it started generating a very vague error message:
"Unable to get records. Object reference not set to an instance of an object"

When I point the application at test version of the database it does not error.

When I point a dev version of the application at the production db, it does error.

The dba ran a trace while i was using the app and did not see any db access

The normal dbcheck and other dba diagnostics show no issues.

Security has not been changed.
The DB has not been changed.
The app has not been changed.

In trying to debug using the VS2008 IDE, i get to this routine:
Public Shared Function GetRecordCount(ByVal where As WhereClause) As Integer

Return CInt(AppDebugLogTable.Instance.GetRecordListCount(where.GetFilter(), Nothing))
End Function

this call generates the exception. Obviously there is an error class that hides the real .net error and lower level components you get from the exe.tostring.

This is called from:

' Read data from database. Returns an array of records that can be assigned

' to the DataSource table control property.

Public Overridable Sub LoadData()

Try

' The WHERE clause will be empty when displaying all records in table.

Dim wc As WhereClause = CreateWhereClause()

If Not wc Is Nothing AndAlso Not wc.RunQuery Then

' Initialize an empty array of records

Dim alist As New ArrayList(0)

Me.DataSource = DirectCast(alist.ToArray(GetType(AppDebugLogRecord)), AppDebugLogRecord())

Return

End If

Dim orderBy As OrderBy = CreateOrderBy()

' Get the pagesize from the pagesize control.

Me.GetPageSize()

' Get the total number of records to be displayed.

Me.TotalRecords = AppDebugLogTable.GetRecordCount(wc)

This is on app start up but I have been unable to figure out what the where clause looks like. it seems to be wc.runquery = true

can anyone help?

Forum: Running & Deployment Issues V5.X

SetFocus after postback

mdowney — Thur, 19 Nov 2009 15:55:18 GMT

Hello all.
I am using Net 2.0 and have the following code, but the focus always returns to my first field on the screen which happens to be a calendar control and it will auto pop-up again after a postback is fired.

Dim TotalGross as Decimal

if Me.MTDTotalPurchasePrice.Text = "" then

Me.MTDTotalPurchasePrice.Text = "0"

end if

if Me.MTDTotalRecon.Text = "" then

Me.MTDTotalRecon.Text = "0"

end if

TotalGross = Decimal.Parse(Me.MTDTotalSalePrice.Text) - (Decimal.Parse(Me.MTDTotalPurchasePrice.Text) + Decimal.Parse(Me.MTDTotalRecon.Text))

Dim number As Decimal = CType(TotalGross, Decimal)

Me.MTDTotalGross.Text = Cstr(Number)

Me.MTDTotalPurchasePrice.Focus

What am I doing wrong?

Forum: Using Iron Speed Designer V6.X

Migration to 6.2 iron speed version

amruta — Thur, 19 Nov 2009 05:21:40 GMT

Currently we have Iron Speed Designer Enterprise Edition Version 5.2.

We want to upgrade its version to 6.2.

Is it needed to buy Enterprise Edition for version 6.2?

Is there any other way? If yes then can you please send us the steps for up gradation?

Forum: Using Iron Speed Designer V6.X

Time values and scheduling

RichardRay — Thur, 19 Nov 2009 00:21:04 GMT

SQL Server stores datetime values, there is no data type (of which I am aware) that stores only time values. When doing scheduling applications the time is often the important piece. ISD allows me to set a datetime column from SQL Server to display only the time portion, but the underlying data is still the datetime.

Given that, what have folks developed to make entering time values easier? Something like a spinner?

How do you approach wanting to be able to find out if a row was created earlier that 11:00 AM (or whatever time) on *any* date?

Some of that's a SQL question, but of it's ISD, too. Any suggestions.

Forum: Using Iron Speed Designer V6.X

How do I display multiline fields?

JohnHadj — Wed, 18 Nov 2009 23:01:02 GMT

I think I'm missing something ...

I have some nvarchar(max) fields.

Edit Record pages show them as multiline and when I edit the contents I can put in newlines and they display in the edit field as multiple lines.

In the Show Record or Show Table page the newlines seem to be stripped out and the field displasy as one long (possibly wrapped) line.

When I go back to Edit Record, the field is shown as multiple lines.

How do I get the fields to Show as multiple lines?

John

Forum: Using Iron Speed Designer V6.X

Sql statement help

byrnewebb — Wed, 18 Nov 2009 20:12:38 GMT

I have the following sql statement:

SELECT adrivers. ,adrivers. , unit. , unit. , adrivers. , adrivers. , adrivers. , unit. , ym0801.

FROM , ,

WHERE adrivers. = unit. and adrivers. =ym0801. and ((unit. = ?) AND (unit. < ?)) ORDER BY DESC

I have several different tables that I would like to select from for the ym0801 table. Any ideas on how to input a variable as is done with the apuyesno and 90day.
Thanks for the help

Forum: Code Customizations V5.X

6.2.1 Unable to select multiple cells

bonkjuggler — Wed, 18 Nov 2009 19:45:41 GMT

We're having a problem on a HP Compaq 8510p laptop when using ISD 6.2.1. This problem does not exist on this same computer when using 5.2.1 and 6.1.

When in the designer area I click on a cell, and then hold down shift and click another cell to select the entire range of cells. The result is the new cell is the only one that is highlighted, it will not select the range. The behavior is just as if we never held down shift at all. None of any of our other pc's or laptops have this problem. Again, this is not a problem at all on this same exact pc using 6.1.0 or 5.2.1. We've also tried multiple applications and they all do the same thing.

We've looked at the keyboard settings in the computer, but cannot find anything that might indicate what is causing this. No other application on this application is having this problem either.

Ideas anyone?

Forum: Using Iron Speed Designer V6.X

Wanted! Friendly ISD Developer

romilb — Wed, 18 Nov 2009 19:18:44 GMT

Hi All;

I m in the process of developing an application with ISD
Backend is MSSQL server-
I have started with the application but now I need to someone to help me with customizations and to help launch it. I would like the person to share some knowledge with me as well as Im a beginner in ISD
Please send me your info with hour/rates to romilb@gmail.com

Thanks and hope to hear from you soon

Forum: Using Iron Speed Designer V6.X

Weird display issue in 6.2.x

pkoutoul — Wed, 18 Nov 2009 18:53:34 GMT

All of a sudden, I am having some strange display issues. It started today with 6.2.0, which I have used a few times in the past few weeks with no problem. I tried upgrading to 6.2.1 with no change in the behavior.

The first thing I notice is when I first launch ISD or switch back to it from another active window, and then mouse-over the ISD application menu, each item on the menu jumps a few pixels up and left as it is being moused-over. If I hit ALT, they all jump simultaneously. Also, the entire grid-view "spreadsheet" portion of the application seems to jump similarly when the focus is being moved to or from ISD, and it appears as a sort of ghost image over the other application being switched to.

That is annoying, but the real problem occurs when I open any dialog while in design mode. The ghost image of the grid persists and obstructs my view of the dialog. See attachment. Anyone else have this problem? None of my other applications have started having problems like this, just ISD. Weird.

Forum: Using Iron Speed Designer V6.X

Custom Large List Selector not updating

rawales2 — Wed, 18 Nov 2009 17:40:11 GMT

I have followed the instructions in 6.2 for making a custom large list selector (lookup link button) per the help and everything works up to the point of populating the text box on the record add page.

I think it has something to do with the code in the customlargelistselector.controls.vb page. I have put this in the record row class-

Protected Overrides Sub Control_Load(ByVal sender As Object, ByVal e As System.EventArgs)

        MyBase.Control_Load(sender, e)

        Me.CustID.Attributes.Add("onClick", "UpdateTarget(""" & Me.CustID.Text & """); return false;")

End Sub

And when you click on the CustID, the window closes but nothing populates in the CustID text box on the add record page where the lookup link exists.

Thanks in advance.

Forum: Code Customizations V6.X

Adding custom ascx control in page

ranjithp — Wed, 18 Nov 2009 16:27:42 GMT

Hi,

I am using Iron Speed Designer v6.2.1 enterprise edition.

I have a requirement in which a set of controls are used in multiple pages. so i created a Custom ASCX control (user control) using the Iron Speed designer.

Now the problem is, i could not find the option to add the user control to the ASPX page. could anyone help me in solving the issue.

Is there any option to add custom ascx control to a page in ISD or should we do it from visual studio.

Thanks in Advance

Forum: Using Iron Speed Designer V6.X