von VBeXpress.com - Produkttyp: Anwendung
in Codeerstellung/-bearbeitung
Weitere Information auf dieser Seite wird nur als geschichtliche Referenz angezeigt und könnte sich seitdem wesentlich verändert haben.
It seems that I am only one who still have to support code generated by of this product.
I needed to update one table. I've opened "Refresh", select the particular table (marked as Updated) and click Refresh.
Error was reported.
The database tree has updated table, but classes tab didn’t have the class for the table.
I had to delete the table from the database tree and click refresh to add the table as new.
It worked this time and created corresponding class.
Antworten
RE: Error during "Refresh" of up... office [The Netherlands] 08-Apr-2008 18:54:21
Hi Michael,
You are not the only one still using vbexpress. I do to, but i lost (broke) my computer and the installation of vbexpress. So i reinstalled vbexpress but cannot find my serial code of vbexpress. Those people do not respond to email. Do you still have contact with them or can you provide me with a valid serial.
You can contact me through this forum or online through office@marcelvreuls.com. I have a valid license of vbexpress but lost it.
Thanks for your help.
Marcel
AntwortenRE: RE: Error during "Refresh&qu... michaelf [Australia] 28-May-2008 13:36:01
I am not working any more for the company, that had licence for VBexpress and I do not have the installation files.
Antworten
VBeXpress.NET provides an OleDb helper class adapted from the .NET Data Access Architecture Guide.
It's located as Templates\VB.NET Winforms\MSAccess\SQLHelper.vb which is quite useful.
Note that 3.0 version (31/12/2003) has problem with ExecuteReader that doesn't re-throw exception.
The correct catch block should have throw
Catch
'if we fail to return the SqlDatReader, we need to close the connection ourselves
cn.Dispose()
Throw 'MNF added 18/4/2005
End Try
Antworten
RE: VBeXpress.NET error handling in Access... davehouse [USA] 09-Aug-2006 20:31:22
We purchased the VBeXpress.NET Ver. 3.0 from a vendor, and tried to register it with Data Cast.
They are apparently out of business. They do not respond to any emails, and their phone just rings.
I am looking for the source code that would have been provided upon registration for their controls. Can anyone help ut out with this?
Antworten
Has anyone even generated code out of this tool? It won't let me do it. It says I have to create a project first. But I did. I clicked on New from the File menu and filled out the form. Nothing happens and support won't respond to emails.
Antworten
RE: VBeXpress.NET MIchael Freidgeim 06-Apr-2005 03:59:51
I am using VBeXpress.NET (3.0) for a year for ASP.NET application development. There are many bugs/enefficiencies in the generated code and in the generator GUI itself. Fortunately, most of them can be fixed by modifying templates. The biggest disadvantage of VBeXpress is their very poor support: they ignore most questions. You should send them many e-mails and pray that they will reply.
I didn't have a problem with creating new database/project. I am using SQL Server 2000. Have you seen any errors during creation?
It's possible that VBeXpress doesn't like some table. (look at statusBar at the bottom - it could show which steps are passed)
You can try to start with simple database and then add additional tables/views/sps from your real database.
Regards,
MIchael Freidgeim
AntwortenRE: RE: VBeXpress.NET marcel [The Netherlands] 17-Aug-2005 10:38:56
Hi Michael,
I have the same problem with the guys from vbexpress. The product is good (for me) but the support realy s*cks but anyway. Are you willing to share your templates with me, perhaps yours work better dan mine :-)?? I have the following problem with access db and sql server db.
When starting the c#, web app from the vs ide and stepping through the code it all works fine!!!! but when starting the app from a url all changes to the database concerning ADD/UPDATE and DELETE are not working from the detail forms. Editing right into the grid (i use vbexpress grid and/or microsoft datagrid) works very well. So i guess it is no permissoen etc problem but i cannot find out what the problem is because debugging gives no errors.
Any help is very welcome.
Thanks, marcel
Antworten
There are several issues with templates if SQL Server column is GUID.
1. If I have Guid as a column, it causes the errors like following
VB.NET Webforms\uscSubscriptionSearchInterestDetails.ascx.vb(453): Value of type 'String' cannot be converted to 'System.Guid'.
staObject.SearchEngineGuid = CType(Me.txtSearchEngineGuid.Text, Guid)
VB.NET Webforms\uscSubscriptionSearchInterestList.ascx.vb(303): Value of type 'String' cannot be converted to 'System.Guid'.
SubscriptionSearchInterest.SearchEngineGuid = strSearchEngineGuid
VB.NET Webforms\uscSubscriptionSearchInterestSearch.ascx.vb(176): Value of type 'String' cannot be converted to 'System.Guid'.
Return CType(Me.txtSearchEngineGuid.Text, Guid)
The special handling using ToString and new Guid(string) is required instead of CType
2. MS SQL Server SP Update template doesn't work with GUID generates the following SQL code
SET @Parameters = ''
+ ' SubscriptionId:' + COALESCE(CONVERT(VARCHAR, @SubscriptionId), 'NULL')
+ ' SearchEngineGuid:' + COALESCE(CONVERT(VARCHAR, @SearchEngineGuid), 'NULL')
which causes error
Insufficient result space to convert uniqueidentifier value to char.
For Guid CONVERT(VARCHAR(36), @SearchEngineGuid) should be used.
It seems that all SP templates should be fixed to support GUIDs.
3.I have a table with SQL Server uniqueidentifier column, and my application is responsible to populate the value, not database using newid().
VBExpress SQL SP insert template always generates new GUID, even if I pass the valid one.
It’s not correct.
Also in VB.NET Webforms\usc...Details.ascx.vb AddData GUID is not populated even if my application is responsible to populate the value.
Michael Freidgeim
Antworten
I tried to do VBeXpress.NET SQL-Server InstallationVersion 3.0.0 - January 2004.
I am running Microsoft SQL Server 2000 .
However Setup stops with message "Target SQL Server version must be 7.XX or higher".
After investigation I found that setup batch failed, because I didn’t create a new database.
The message is absolutely confusing and ideally batch file should create the new database automatically.
Hopefully this post will help someone with the same problem.
Michael Freidgeim
Antworten
Hello all,
Beacause VBeXpress support is absolutely helpless and they don't want to have their own support forum, I will try this forum with hope that some VBeXpress users read it.
I’ve added a new column to some existing in the project table(SQL Server)
Refresh list showed that the table was updated and I select it to refresh.
Now the new column is in the Database View, but is not visible in Project/classes view.
What should I do to add the new property to the class?
Thanks,
Michael Freidgeim
Antworten
RE: VBeXpress.NET -A new column not added ... michaelf [Australia] 26-Nov-2004 04:57:19
The error happened when in the same refresh I’ve added a new reference(Master) table and also a new column to some existing in the project table, that is a foreign key to the just created reference table.
No errors were reported, but a new property was not added to the existing class.
After investigation in VbExpressNet.mdb I found that also tblClassProperty.DatabaseFieldID values of the modified class refer to the old (non-existing now) tblColumn records.
With several attempts and guessing based on table and column names(fortunately they are meaningful)
I manually changed tblClassProperty.DatabaseFieldID properties,
added a new property to tblClassProperty and 4 records to tblClassPropertyControl,
added new relationship records to tblClassPropertyProperty and tblRelationshipTableColumn,
also added disappeared records in tblClassPropertyProperty.
It seems that the new property is now added properly.
It was not an easy task.
I am not sure if any procedure exist to avoid this problem again?
May be it will be better if I would “refresh” twice- to import new reference table first and then refresh table with new foreign key?
Or refreshing Updated Table never works? ( I don’t remember successful refresh of updated table with my database)
Any thoughts would be appresiated.
Michael Freidgeim
AntwortenRE:VBeXpress.NET -A new column not a... Michael Freidgeim 28-Nov-2004 22:58:19
I've got the response from VBexpress with 2 main ideas.
1.Do not use Refresh.
2.Do not use UI to customise project, but use customisation script (see Templates\Support)
-----Original Message-----
From: VBeXpress Support [mailto:support@vbexpress.com]
I’m afraid to report that the database Refresh function is not 100% working.
Normally I proceed as follows
1) Import database
2) Create project
3) Create project customisation file (see Templates\Support)
4) Run Cusomtizatrion template
5) Repeat 1-5
That way you can continue to import databases as it changes and keep any project customisations. Not ideal but it does get around the Database Refresh problem
Antworten
Hi,
could anybody please tell me, when a version of VBeXpress.NET will be released, which supports Oracle databases?
Regards,
Carsten
Antworten
ComponentSource bietet einen einzigartigen, globalen Service an, der weltweit von über 1.000.000 Entwicklern benutzt wird.