Crystal 11 and Delphi 7
Hello. I use CR11 and the VCL in D7. In the code, I have a front end query processor. The Crystal vcl has a property named filterstring and that is how I do record selection. What I want to do is be able to print one of the selection parameters in the report. If I drop a text object in the header in the Crystal designer, is there a way to burrow into the report fields from the Delphi code to force content into the field?
For example, say I have a transaction report. I select transactions with a start/end date in the Delphi app. Within the Crystal report itself, I want to somehow forc...How to call or retrieve fields from sql and display in table without using ADO.net, I'm using a dynamic link library....Is the coding different?
Help me! I'm doing my school project on Software Change Management Tool, CR Tracker. I want to display table in the webform, and the table data is retrieve form the sql server. So how do I call the sql so as to display the data in a table?
hy..What does that dll contain ?Does it already contains relevant code to connect to a database ?
Have a look hereThanksDinuj Nath
The easy way to do this is with the use of a data bound grid. The Grid can be customised to look and feel you like. You will need to add a data adapter to your page and a grid. When you setup the data adapter you will nee...Can ADO.Net query/update a MS Access database that contains table and fields that contain blank spaces and characters such as "#" in their names?????
I've recently been assigned an asp.net/MS Access project. My code works fine; however, there are table and fields in the Access database that contain blank spaces and characters such as "#" in their names.
For example there is a table named "Purchase Orders" and in this table there are a few column fields with names such as "PO#" and “Customer PO#".
My question: Is there some sort of wrapping method that I need to implement to allow my ADO.net objects (particularly the "OleDbDataAdapter" and the "DataRow") to accept these naming...Access to code table
If I have a column on a datawindow of type DDLB, can I get access to the
code table of that edit style? For example if I define a DDLB with the
following code table:
Display Value Data Value
how can I get to these values at run time?
Try to use GetValue function.
Juan Garcia <email@example.com> wrote in message
> If I have a column on a datawindow of type DDLB, can I get access to the
> code table of that edit style? For example if I defin...Code table access
I am using code table in a grid datawindow. The problem is how I can get the
edited value from the column.
Two lines in code table: display data
The grid has two lines width displayvalue 20.1 and 23.6. If I edit line 1
and change the value to 23.6 (same as line 2 in code table) I am not able to
get the edited value from line 1 in the itemchanged event of the
datawindow. Gettex() and data argument gives me both value 52.3 (the
...accessing a field from a table?
35...accessing a table fields
I have a seperate table and i want to show the fields of another table in this new table.
Is there any hint to do it.
...Access to fields in a table
I am trying to access the fields in a table using Visual Basic in Web Developer .NET
Start with the link below and click on SelectCommand, InsertCommand, DeleteCommand and UpdateCommand to get tbe basic of manipulating data in the database through ADO.NET. Hope this helps.
<input id="txtName" type="text"/>
<input id="txtAdd" type="text"/>
<input id="txtCity" type="text"/>
<input id="btnAdd" type="button" value="Add" onclick="AddClick();" />
<input id="btnRemove" type="button" value="Remove" onclick="RemoveClick(this);"/><br />
<table id="tblInfo" runat="server" style="width: 474px" >
</div&g...Is having a trigger that inserts a row in Table 'A', when a row in same table is inserted by ADo.Net code?
I want to insert a row for a Global user in Table 'A' whenever ADO.Net code inserts a Local user row into same table. I recommended using a trigger to implement this functionality, but the DBA was against it, saying that stored proecedures should be used, since triggers are unreliable and slow down the system by placing unecessary locks on the table. Is this true OR the DBA is saying something wrong? My thinking is that Microsoft will never include triggers if they are unreliable and the DBA is just wanting to offload the extra DBA task of triggers to the programmer so that a s...Do the fields in a Table Adapter have to exactly match the fields of the Data Table?
When I add a new Table Adapter to a Data Table I get the following error:
The new command text returns data with schema different from the schema of the main query....
I'm using less fields than the Table Adapter used so I'm guessing that is bad and I should just create a new Data Table for my needs. Is that true?
...How to Access SqlDataSource Fields from Code?
I have <asp:SqlDataSource> in aspx page that is being used by an updateable GridView. However, there are a couple fields in the dataset that contain filenames that I want to access directly in code and place them into some image tags on the page. This line should give me access to the dataset but how to I access the fields?
Dim myDataSource As DataView = DirectCast(SqlDataSourceGridView.[Select](DataSourceSelectArguments.Empty), DataView)
When the SqlDataSource is a DataReader I would access it with the code below but since this SqlDataSource is a DataS...Adding field to Access table?
This may sound like a dumb question and I apologize ahead of time. I found the access database 'DotNetNuke.mdb.resources' which is where the data is being stored.
I added a field to one of the tables, specifically the 'DotNetNuke_Banners' table. Basically, I've added a description field that I want to appear with the banner ads. I've also updated all the queries in the database which reference this table.
Now, the dumb question: I cannot find where to add this field in the site? In the old IBuy Spy portal you had the xxxDB.vb files in the components directory where you would updat...Direct access to the fields in a table
I want to access the fields in a table directly. How can this be done?
Is the table asp:Table or html table? Post relevant code.
The tables would be in ASP.
I was hoping for a simple example to get me going. I have never done it before and the training sites have so much information before getting to the point.
If you can help me I would appreciate it.
Can you please explain about your scenario? What kind of table and controls you want, is the values will be data driven, and when and what kind of information do you want to retrieve? If you give that, the...Convert Delphi 5 ADO App to Delphi 2007 ADO.NET
I have an appliction tha that is writen in Delphi 5 with ADOConnetion, ADOTable, and ADOQuery components.
I need to upgrade to Delphi 2007 and use ADO.NET.
I have the program building in with Delphi 2007. Is there anything I need to do to convert the ADO to ADO.NET?
> I need to upgrade to Delphi 2007 and use ADO.NET.
With best regards,
AnyDAC (www.anydac.com) - Oracle, MS SQL Server, IBM DB2, MySQL,
Firebird, Interbase, PostgreSQL, Sybase ASA, SQLite, MS Access, DBX,
ODBC, InMem - universal high-speed native data access engine
Reasons for ...