This topic is locked
[SOLVED]

 Update generation after change in BD

7/8/2004 8:21:40 AM
ASPRunnerPro General questions
author

Hello,
I have change the database structure.
I delete all asp file and I generated all. But on the articles-edit files asp it have the fieds that before and the new.
And it genrated and error :
Add new record
--------------------------------------------------------------------------------
ASP error happened
Technical information

Error number -2147467259

Error description SQLState: 42S22

Native Error Code: 1054

[TCX][MyODBC]Unknown column 'genre_presentation' in 'field list'
URL /administration/articles_edit.asp

SQL query select ref, titre_article, lien, auteur_principal, tel_fax, code_postal, genre_presentation, decision, approbation_comite, commentaire, auteurs_secondaires, organisation, adresse, Email, theme, pays, date_depot, genre, theme_retenu, theme_souhaite, presentation_souhaitee, presentation_retenue, numero_session, date_session from articles where 1<0
More info on this error
---------------------------------------------------------------

genre_presentation has been replace by presentation_retenue and genre_presentation didn't as been removed.
But the asprunner generated some old field.
How can I update the generation ?

Thanks
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=719&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />

Alphonse

Sergey Kornilov admin 7/12/2004

Alphonse,
try latest version of ASPRunnerPro where this problem is fixed:

http://www.asprunner.com/files/asprunnerpro31a.exe